Microsoft Office Forums - View Single Post - [Solved] Need help on duplicates in column; deciding which to keep based on other column

Thread: [Solved] Need help on duplicates in column; deciding which to keep based on other column

View Single Post

Old

01-30-2014, 04:35 PM

nwcf

nwcf is offline

nwcf uses Windows 7 64bit

Windows 7 64bit nwcf uses Office 2010 32bit

nwcf uses Office 2010 32bit

Office 2010 32bit

Novice

The original poster

Join Date: Jan 2014

Location: bethesda, md

Posts: 2

nwcf is on a distinguished road

Default

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.

Reply With Quote