Forum Discussion
Solved
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...
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.
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.
