how can i exclude dubble numbers in a vertical row

  • Thread starter Thread starter Jan
  • Start date Start date
J

Jan

4440558
4440558
4440558
1234567
1234567

all i want is that i see every number once
 
Select your data range, then go to Data-filter-Advanced Filter.
For the Criteria box, input the range ocntaining your numbers, then check
the box "unique records only". Then filter.
 
Use the Advanced filter option from the Data menu and check "Unique records
only"

Regards,
Per
 
You must log in or register to reply here.

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

Problem With Text & number format 1
start and end date on different rows 1
Excel How to Autocomplete text/string within a single cell, between different worksheets 1
Comparing 1 number to 1000's and returning corresponding name 6
How to parse data 1
Summing up Unique Records 1
Extracting 7 digit number from alphanumeric string 10
Delete duplicates in a row 3

Back
Top