Excel 2007: Delete Duplicates

[John Keith]

Excel 2007 has a wonderful Delete Duplicate Rows function.

But I want to hide the duplicate rows rather than delete them. It
appears there is no way to change the behavior of this function from
delete to hide.

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

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


John Keith
(e-mail address removed)

 

[John Keith]

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
(e-mail address removed)

 

[soportei28]

Possible solution

Hi!, you may try the solution posted here: http://www.tech-recipes.com/rx/2928/excel_2007_how_to_hide_duplicate_records_in_a_spreadsheet/

Hope it helps.

--