Hello,
I am looking for a function, similar to SUMIF, but for text instead of numbers. I have looked at using INDEX MATCH but this does not allow me to set a criteria. The example data is below:
Reason for Absence Department Injury Outside Work Production Cold/Flu Production Headache/Migraine Production Cold/Flu Production Cold/Flu Research and Design Cold/Flu Research and Design Infection Administration Gynaecological Administration Infection Administration
I want excel to search for the criteria, e.g. Administration, and then look for the most common text in the Reason for Absence column.
Is this possible?
Thank you in advance.
Bookmarks