show only 1 of each variation

C

Carla

I have a spreadsheet with 4 columns of data. I would
like to somehow display only 1 of each unique row(hide
all duplicates).

Example:
1)8810 5100 3830 300104
2)8810 5100 3830 300104
3)8742 5100 3830 300104
4)8810 5100 3830 300105

In this example I would only want to see rows 1, 3 & 4.

Thank you all for the great work you do here!
Carla
 
N

NH

One way
select the block of data then go to Data-filter-adv filter and check unique
records
 
G

Gord Dibben

Carla

If you're looking for uniques, I would suggest that 1 and 3 only should be
shown.

Use Date>Filter>Advanced and Unique record only and copy to another spot.

Gord Dibben Excel MVP
 
Top