Maximum value for each distinct name
I have a spreadsheet with info about 10,000 bird photos. Each row gives the bird name, with a rating from 0 to 5 for the quality of the photo.
I want to extract a list of unique bird names, and for each bird, I want the highest quality rating among photos of that bird. Armed with this list, I can go on a bird photography trip, prioritising which birds I am likely to see, that need a better photo.
I don't think I can do this with filters, and no-duplicates - does anyone have a solution?