Hello,
I am trying to generate a list of the five most common text occurrences using criteria to filter the results.
So far, I am able to create an INDEX MATCH function to identify which text occur most frequently in a range using criteria, but if I copy this formula down, I duplicate the result. Instead, I am using a different formula for results two - four, but do not know how to modify it so I can include my criteria. Can someone please explain how I can implement the criteria into the formula for the remaining four results?
Please find a copy of my workbook and let me know if you need any clarification.
Kind regards,
preppy_prince
preppy_prince_Example_30052023.xlsx
*UPDATE*
I have amended my workbook as I realised I need to return results based on more than one criteria, with each criterion containing multiple 'correct' values which my formula is unable to account for.
The criteria I am now wanting the INDEX MATCH function to refer to are:
- D2:D31 | "Full-time" or "Part-time"
- E2:E31 | "Trainer" or "Trainee"
This should return the result 'Emma', (as her name appears the most out of all texts in B2:B31 which also satisfy the two criteria) but instead I am receiving #N/A.
preppy_prince_Example_30052023_V2.xlsx
*UPDATE*
New workbook where I am trying to return results using multiple 'or' criteria:
preppy_prince_Example_30052023_V3.xlsx
Bookmarks