View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ali ali is offline
external usenet poster
 
Posts: 1
Default Identifying duplicates/unique values

Hi,

Would anyone be able to help me with the following please.

I want to select a range of rows use a macro to identify which of thos
entries are duplicates - ie the entire row matches another row in th
selection?

In an ideal situation the duplicates will be moved to a new sheet
called duplicates - with the unique rows being moved to a new shee
called uniques.

The original data will remain in the original sheet.

Many many thanks for any help you can offe

--
Message posted from http://www.ExcelForum.com