Hi,
See attached document.
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 A is the list of names. In column B i want to find the highest score in relation to that name. In column C i want the lowest points in relation to the name and Column A.
Thanks,
Bookmarks