Forum Discussion
Work4Rose
Oct 18, 2019Copper Contributor
Complex Text Formula?
I am crunching some data to find patterns. Of course people stopped filling in data in a certain area, and I need that data to get a clear picture. Let's pretend Medical Specialty requested is column...
- Oct 19, 2019
I tried the fuzzy matching through power query but I don't think that it is producing the desired output considering the data in your data table and the data in your Specialty list on sheet.
Look at the column D with a Vlookup formula which you can copy and paste as Values in column E if you are satisfied with the output returned by the formula and then delete the column D.
Subodh_Tiwari_sktneer
Oct 18, 2019Silver Contributor
You cannot have both the formulas and manual entries in the same column.
If your column A is already populated with some Medical Specialty Requested and you want to populate the cells with Cardiology if the corresponding cell in column C has Cardiology in it, you may follow this approach...
- Insert a Column before Column A.
- In the newly inserted column (which should be the column A currently), place the formula =IF(ISNUMBER(SEARCH("Cardiology",D2)),"Cardiology",IF(B2="","",B2)) in the cell A2 and then copy it down.
- Now select the range A2:A10000 ( or whatever range with the formula in column A) and copy it by pressing Ctrl+C.
- Select the cell B2 (which should be your existing Medical Specialty Requested column) and paste the copied cells as VALUES only or press the shortcut key Alt,e,s,v and hit Enter.
- Remove the Column A.
Hope that helps.
Work4Rose
Oct 18, 2019Copper Contributor