View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Keith John Keith is offline
external usenet poster
 
Posts: 172
Default Excel 2007: Delete Duplicates

What is my best option/method to hide rows with duplicate data?

I only care about checking for duplicate data in one column.

I think I have a very simple solution.

I have a main loop that goes through every row and within the main
loop I have a second loop that looks at each row below the current row
and if the data in the criteria cell is the same then I just hide the
row.

It seems ot work but it will take some close review to make sure it's
doing what I want it to.


John Keith