Hi,
See attached document. I am trying to use this in Googlesheets. I have a formula that works for Excel, but the formula "AGGREGATE" does not work for googlesheets.
In sheet 'data' i have a list of names. The names are displayed more than once. next to each name are numbers.
In sheet 'results' column B is the list of names. In column X i want to find the highest score in relation to that name. In column Y i want the lowest points in relation to the name and Column B.
Thanks,
Bookmarks