I have a massive list of donor information spanning two years of donations in Googlesheets. The list includes names, contact info, and the donation amount. Many folks have given multiple times over the last two years. I need to reduce the list and plan to delete duplicates, but I need to keep their information pertaining to the highest donation amount. Essentially, looking to create a list with no duplicate contacts that contains the highest donation amount for each contact that they gave. How do I make this happen?
I tried format and conditional formatting, but I don't know how to set the parameter for keeping the row of data with the highest donation value within the set of duplicates.