Posted to microsoft.public.excel.programming

rhys

external usenet poster

Posts: 1

delete duplicate rows

i have a spreadsheet with duplicate email entries.
anyone know of a macro that can go down through the rows,
check to see if an email address is in any previous rows
and if so delete all remaining rows that contain that
duplicate email address?

cheers,

rhys.

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
delete duplicate rows, keep one	Wasdell	Excel Discussion (Misc queries)	1	October 30th 09 12:16 PM
Delete rows with duplicate values	One-Leg	Excel Discussion (Misc queries)	1	February 17th 08 06:49 PM
delete duplicate rows	christinaLO	Excel Worksheet Functions	1	February 27th 07 06:22 PM
Delete rows with duplicate values	Smohrman	Excel Worksheet Functions	14	May 5th 06 12:20 PM
How do I delete both duplicate rows from a spreadsheet?	natalia	Excel Discussion (Misc queries)	3	April 29th 06 11:40 PM

All times are GMT +1. The time now is 12:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us