Posted to microsoft.public.excel.misc

Gord Dibben Gord Dibben is offline

external usenet poster

Posts: 22,906

Duplicate Entries

DataFilterAdvanced Filter.

Check "unique records only" and "copy to a new location".

For more on this see Debra Dalgleish's site

http://www.contextures.on.ca/xladvfi....html#FilterUR

Gord Dibben MS Excel MVP

On Wed, 23 Aug 2006 17:01:02 -0700, Phxlatinoboi®
wrote:

I get a report once a month that has duplicate entries. I would like to take
out all the duplicate entries. Is there a formula I can use for this or what
would be the easiest way of taking out the duplicate entries.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
removing duplicate entries	armagan	Excel Discussion (Misc queries)	1	June 12th 06 05:42 PM
Duplicate Entries	ConfusedNHouston	Excel Discussion (Misc queries)	1	November 1st 05 12:50 PM
problem tagging duplicate entries	julz	Excel Worksheet Functions	5	June 30th 05 01:59 AM
count duplicate (or, inversely, unique) entries, but based on a condition	markx	Excel Worksheet Functions	3	March 8th 05 06:57 PM
Add numbers for duplicate entries then delete	Chillygoose	Excel Worksheet Functions	1	November 2nd 04 04:35 PM

All times are GMT +1. The time now is 03:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us