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....