Deleting repeating item #'s

[matmich]

I have a list of 18,277 item #'s of which there are some that repeat.
How can I generate another list which only list each unique item#

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/duplicat.htm#ExtractingUnique

 

[Norman Harker]

Hi matmich!

See:
Chip Pearson:
http://www.cpearson.com/excel/duplicat.htm#ExtractingUnique

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Max]

One way to get the unique list is via Advanced Filter

Assume the items are in col A
with col label (eg: Name) in A1,
data in A2 downwards

Select col A

Click Data > Filter > Advanced Filter

[Click OK to the Excel prompt to use the first row as labels]

In the Advanced Filter dialog box:
Check "Copy to another location"
Put for "Copy to:" : B1
Check "Unique records only"
Click OK

The unique list will be extracted in col B