I want to do an xlookup where there are multiple matches and get excel to return the maximum value:
e.g. My lookup value is "cat". My lookup range is column A and I want excel to return the max value from column b for "cat":
Column A Column B
Cat 3
Dog 1
Cat 12
Cat 4
Have attached spreadsheet. I'm sure there's a simple solution for this!
Thanks!
Bookmarks