Duplicate Entries

[TomRobertson]

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

 

[joel]

Do you have more than one account on a worksheet? Not clear from your posting?

Is each column a difffernt month?

Can you use the formula =MAX(B1:B10) at the bottom of the worksheet to get
the maximum of each month?