Need help on duplicates in column; deciding which to keep based on other column

		Microsoft Office Forums > Microsoft Excel > Excel
Need help on duplicates in column; deciding which to keep based on other column

FAQ

Thread Tools

Display Modes

01-30-2014, 04:35 PM

nwcf

Windows 7 64bit Need help on duplicates in column; deciding which to keep based on other column

Office 2010 32bit

Novice

Join Date: Jan 2014

Location: bethesda, md

Posts: 2

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.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:54 AM.