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