Is there a Function...

[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?

 

[Ken Wright]

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.

 

[Frank Kabel]

Hi
one way:
- select your column
- goto 'Filter - Advanced Filter'
- Choose 'Unique'