Posted to microsoft.public.excel.programming

UK[_2_]

external usenet poster

Posts: 2

Delete Duplicate rows in a range

In Excel I need a way to delete duplicate rows based on
more than one column.eg:

Original Data in a range of cells:

A 1
B 1
C 2
A 3
A 1
B 2
B 1
C 5
C 2

Resulting data after deleting duplicate rows should look
like below

A 1
B 1
C 2
A 3
B 2
C 5

Any help is appreciated. 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, keep one	Wasdell	Excel Discussion (Misc queries)	1	October 30th 09 12:16 PM
delete duplicate rows	christinaLO	Excel Worksheet Functions	1	February 27th 07 06:22 PM
HELP delete duplicate rows.	Malcolm	Excel Programming	2	September 29th 03 11:48 AM
Delete duplicate rows	christina	Excel Programming	1	August 4th 03 01:04 PM
delete duplicate rows	rhys	Excel Programming	2	July 29th 03 12:52 PM

All times are GMT +1. The time now is 10:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us