Oct 18 2019 09:33 AM
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 A, Modified is column B, etc.
Basically I need something like, "If the word cardiology is in column C1, put the word cardiology in A1. If not, do nothing." How would you do this? There's probably 10,000 lines and doing it manually isn't an option. Also, I'm in Excel 2013.
Oct 18 2019 10:28 AM
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...
Hope that helps.
Oct 18 2019 10:33 AM
Thank you very much!
Question: I want to get all the specialties into that column. So, first Cardiology, then oncology, then radiology, etc. Would you recommend that I make different columns for each of those, and then combine them after? Oh... I probably wouldn't be able to combine them because they would be formulas and not the actual text I need? How could I do all that?@Subodh_Tiwari_sktneer
Oct 18 2019 10:43 AM
Oct 18 2019 11:51 AM - edited Oct 18 2019 11:51 AM
If you have to look for more than one specialties in column C, you may create a list of those specialties on another sheet which can be used to match with the procedures in column C and if any of the specialties is found in there, the formula would return the correct specialty from the list.
Form you sample data, it looks like it's a partial match.
Why not share a sample file (not an image) after removing any sensitive data from it, if any, along with a list of specialty to match on another sheet? It would be easy for us to suggest a working solution then.
Oct 18 2019 12:15 PM
Thank you sir. I have scrubbed this one of sensitive data. There is another column next to F that also contains more data, but I cannot share that column for privacy issues.
If I am able to get this medical specialties column, I can then create a pivot table showing whether more patients are seeing doctors in certain specialties throughout a period of time.
Oct 18 2019 07:29 PM - edited Oct 18 2019 07:31 PM
SolutionI 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.
Oct 18 2019 07:29 PM - edited Oct 18 2019 07:31 PM
SolutionI 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.