Quote Originally Posted by shg
Then sort the whole ensemble by ID and Query:
Quote Originally Posted by SWQ
removing the duplicate records (i.e., same ID value) and keeping the record with the highest score. How can I do that?
Instead of sorting by ID and query, sort by ID (ascending)and Score (descending).

Then in D1, enter the header myFormula.

In D2, enter and copy down a formula that returns "x" if the row should be deleted.

Copy col D and replace with values.

AutoFilter on col D for x, delete visible rows, unfilter.

The formula I leave to you.