Dear Community, good afternoon from a wet cold London.
Thanks for taking the time to look at this post.
I have found myself at the mercy of Excel again..........
Please find attached a spreadsheet.
In the sheet entitled "Sorted by cc & s" which is already sorted in the following order:
course code (ascending) followed by starts (descending)
I would like to unique the data on course code, that is extract all data, Cols A to Q but only for course codes where the starts are the highest.
I.e, if a course code appears 3 times extract only data where the number of starts (Col H) is highest.
Therefore, I would like to be left with a list of unique course codes with the HIGHEST nuber of starts (col H)
Thanks all.
Darren
Bookmarks