MrExcel Publishing
Your One Stop for Excel Tips & Solutions

suppress duplicates in a column??

Posted by JC on December 03, 2001 4:20 PM

This is a feature I have found helpful in other applications but not finding it in EXCEL.

Say I have Column A thats called "Item" and Column B called "Who Cares". I don't want to continue to see the specific ITEM repeated over & over, rather a blank cell (suppressed duplicate) so that the end user can just focus on the Who Cares Column with out haveing to always glance over at the ITem column, recognizing its the same Item as before.

Posted by Ivan F Moala on December 04, 2001 2:16 AM

have a look @ online help for Autofilter or advanced autofilter