Repeated information in table

[taup41]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Is there a formula I can use to delete or hide repeated information in Excel sheet.
ie: I have 2700 rows x 7 columns, there is 900 different product codes repeated 3 times, is there a simple way of deleting these repeated codes without having to do 900 highlights and deletes.

Thanks

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Is there a formula I can use to delete or hide repeated information in Excel
sheet.
ie: I have 2700 rows x 7 columns, there is 900 different product codes
repeated 3 times, is there a simple way of deleting these repeated codes
without having to do 900 highlights and deletes.

One way to hide duplicates (assuming product codes in first column):

Choose Data/Filter/Advanced Filter:
Action: Filter in place
Unique records only checkbox:checked