Assuming that A1:A6 contains your data, try the following...

1) Leave B1 blank

2) Enter the following formula in B2, and copy down:

=IF(OR(COUNTIF($B$1:B1,A1:$A$6)=0),INDEX(A1:$A$6,M ATCH(0,COUNTIF($B$1:B1,
A1:$A$6),0)),"")

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
babygoode
wrote:

Hi,

I have a list of data which I need to pick out each individual entry
from but some of the data will be duplicated and I only need to pick it
out once. Is this possible?

ColumnA Column B
A
B
C
A
D
C

So in column B i want to list the data but I only want A and D and C to
show once?

Thanks,
Max