I have a data set of property sales that represent properties sold twice over a period of time (each address is represented twice in one column but they are 2 different transactions and the remainder of the row data varies). I am looking for a formula or method to remove the duplicates, but I want to remove the duplicate that sold for less. The entire row is not a duplicate, only the address. There is another column with sale price and I would want it to keep each address of the 2 (or sometimes 3) that is highest. I intend to use a pivot table to analyze and realized that the data is skewed because everything is showing up at least twice.

(sample file is attached- 'Address' column is the column to find the duplicates and 'List Price' column is what determines which row to keep. I want to keep the row with the higher value)

Any help is appreciated!

Thanks.

Attached Files

data sample.xlsx (9.8 KB, 8 views)

Hello
perhaps post a sample file showing what you have and what you need? (no pics please)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I edited the original post and attached a data file.

'Address' column is the column to find the duplicates and 'List Price' column is what determines which row to keep. I want to keep the row with the higher value.

Cross post http://www.excelforum.com/search.php?searchid=2392214

Please read the link in my sig about cross-posting without links - Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post