List Unique Values Using Formula

[LalitPandey87]

Hi Friends,

First of all i would really like to thanks to all of "ExelFox" members for there help, suggestion and for quick reply.
Many Many thanks to u guys.

I am again here after a couple of months with a new query.

I have some raw data (can be numbers or text or both) in a column.
I need only the unique values only by using formula in another column.

I tried it with the helping column but i need the solution in single column without using another column.

like below.


ColA ColB
Jan Jan
Feb Feb
Mar Mar
Jan 1
Feb 2
Mar 3
1
2
3
1
2
3
Feb
Mar
Jan
3
1
2



Thanx in Advance....

[Admin]

Hi Mohan,

Try this array formula in C2 and copied down,

=IFERROR(INDEX($A$2:$A$19,MATCH(0,COUNTIF($C$1:C1, $A$2:$A$19),0)),"")

Confirmed with CTRL + SHIFT + ENTER and not with just Enter !

HTH

[LalitPandey87]

Hi Admin,

It works as i want.

Thanx for ur help. Thanx alot...

[Nishant Choudhary]

great .. n easy to replicate......:o:o

[Ger Plante]

Nice solution....

[Admin]

Thanks Ger and Welcome to ExcelFox !!