How to create the unique list from data

[excelearner]

I have a column (or row) of DATA as Attachment. I want to make a column (or row) of ONLY UNIQUE LIST from the DATA. Any ideas and how many ways to do?

[Paul]

Hi excellearner, welcome to the forum.

Try this:
1. Select column A
2. Click Data -> Filter -> Advanced Filter
3. Select 'Copy to another location'
....The 'List Range' should fill in automatically
....Leave 'Criteria Range' blank
....Set the 'Copy To' box to the cell where you want the unique list (e.g. $C$1)
....Check the box for 'Unique Records only'
....Click OK

That should do it! You can also use Excel Help and search for 'Filter for Unique Records'.

[Ron Coderre]

If you want to use formulas....
Using your posted workbook....

This formula returns the first non-blank item in the list
C2: =INDEX(A2:A20,MATCH(0,INDEX(-ISBLANK(A2:A20),0),0))

This ARRAY FORMULA, committed with CTRL+SHIFT+ENTER
(instead of just ENTER), returns the next ocurring non-blank item:

Please Login or Register  to view this content.

For the remaining unique items,
copy C3 into C4 and down as far as you need.

Is that something you can work with?

[snasui]

Another formula:

C3

Please Login or Register  to view this content.

Ctrl+Shift+Enter and Copy down.