Unique List

[ManUBlueJay]

I am trying to make a simple unique list from a large Column.
There are various options on the web but do not seem to work.
Here is one example that needs to be used in am array.


{=INDEX(list,MATCH(0,COUNTIF($D$4:D4,list),0))}

List is my Column of entries
D4 is the cell right above "List"

It brings back the first 2 uniques but then lists the second many times.
Does anyone see a fix or a better option

</pre>

 

[AhoyNC]

Maybe something like this:
This is an array formula and must be entered with CTRL-SHIFT-ENTER.
This assumes there are no blanks in your list. If you have blanks we will need to make a small change to the formula.

Excel Workbook
	A	B	C
1	List		Unique
2	Test1		Test1
3	Test2		Test2
4	Test1		Test4
5	Test4		Test6
6	Test4		Test120
7	Test6		Test8
8	Test120		Test9
9	Test8		Test100
10	Test9		Test11
11	Test100		Test13
12	Test11
13	Test120
14	Test13
15
Sheet