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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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 03:26 AM.