Is there a Function...

  • Thread starter Thread starter ksnapp
  • Start date Start date
K

ksnapp

Is there a way I can take a column full of numbers (say customer
numbers) that appear more than once and make a list of each number once
somewhere else(like a new page?
 
Select Data and do Data / Filter / Advanced Filter / Copy to Another Location &
Unique numbers only. Choose the new location on that sheet, and then when done
just copy the output to a new sheet.
 
Hi
one way:
- select your column
- goto 'Filter - Advanced Filter'
- Choose 'Unique'
 
Back
Top