I am looking for a way to cut down the amount of time it takes me to 'clean'
account data. I currently get sent monthly accounts which I merge into a
single 12 month spreadsheet. Some of the time there are duplicates between
months and also double accounting within each month. The account number is
often the only consistent entry.

I am looking for a way to filter out a single account from all of these
duplicates but picking only the entry with the highest values and discarding
the rest.

I have been doing a countif on account number and then filtering by account
number to ascertain the entry to bring through - very time consuming.

Would be very grateful if anyone can help.

Thanks