Pull Unique Values from Column

[Shawn1888]

I have a list of numbers in A2:A4000, and these numbers all have duplicates.

What are your thoughts on an array formula that I can place in column B that looks at column A and returns each value found in Column A once?

For example, if I have 1, 1, 1, 2, 3, 4, 5, 5, 5 in column A, Column B would return 1, 2, 3, 4, 5.

I've tried using the below code, and it was able to return some unique values, but it doesn't pull all of them.

Please Login or Register  to view this content.

[AliGW]

You don't need an array formula with CSE. Try this in B2:

=INDEX($A$1:$A$4000,MATCH(0,INDEX(COUNTIF($B$1:B1,$A$1:$A$4000),0,0),0))

[Shawn1888]

Thank worked perfectly.
Thanks Ali!

[AliGW]

You're welcome!