|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need help on duplicates in column; deciding which to keep based on other column
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. Last edited by nwcf; 01-30-2014 at 04:34 PM. Reason: added sample file |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
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. |
#4
|
||||
|
||||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Automatically enter date into a column and make that column read only | Mr Davo | Excel | 1 | 10-29-2012 01:07 AM |
Can I change the horizontal scrollbar to scroll smoothly rather than column by column | carpat | Excel | 0 | 01-10-2012 09:34 AM |
how to create two columns based on a certain criterior from the original two column? | where_pc | Excel | 3 | 06-13-2011 10:39 AM |
Need to search a column for a macth and return a result from a third column | pdfaust | Excel | 2 | 02-03-2011 03:02 PM |
Sequentail Number Each Row Based On Another Column Entry | KramerJ | Excel | 3 | 05-07-2009 11:35 PM |