View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
UK[_2_] UK[_2_] is offline
external usenet poster
 
Posts: 2
Default 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.