show only 1 of each variation

  • Thread starter Thread starter Carla
  • Start date Start date
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
 
One way
select the block of data then go to Data-filter-adv filter and check unique
records
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

please advise 1
Countifs across multiple columns using OR 2
Augmenting an integer in a column to reflect duplicates in another 23
Match and delete rows on two different sheets from reference numbers 4
Excel Programming 7
display repeating row information in columns 1
assigning a unique value 27
Colums of data 2

Back
Top