Posted to microsoft.public.excel.misc

One-Leg

external usenet poster

Posts: 23

Delete rows with duplicate values

Hello,

I have a list of agents in row A (about 3000) and may of them are duplicate
values (sometimes the same agent name is there 5 or 6 times).

Can I do anything to delete the duplicate rows keeping only one row with the
value in question (formula, macro, etc.)???

Thanks!!!

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	christinaLO	Excel Worksheet Functions	1	February 27th 07 06:22 PM
Delete duplicate values	NNothard	Excel Discussion (Misc queries)	4	June 26th 06 04:43 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
Function to find duplicate values, then delete	Cam	Excel Worksheet Functions	1	January 27th 06 01:38 AM

All times are GMT +1. The time now is 08:33 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us