Hi,

I have a column of numbers with duplicates. so the numbers might be


A1 = 33, A2=1221, A3=4, A4=4, A5=4, A6=8392,....

I want to display the numbers without the duplicates - in column B.

Do you know how to do this?

Thanks for your help.

The Advanced Filter can be used. Check 'Unique records only'.
Otherwise, by formula...

1) Leave B1 empty

2) Enter the following formula, which needs to be confirmed with
CONTROL+SHIFT+ENTER, in B2 and copy down:

=INDEX(A1:A$6,MATCH(TRUE,ISNA(MATCH(A1:A$6,B$1:B1, 0)),0))

To trap errors, try the following instead...

=IF(OR(ISNA(MATCH(A1:A$6,B$1:B1,0))),INDEX(A1:A$6, MATCH(TRUE,ISNA(MATCH(A
1:A$6,B$1:B1,0)),0)),"")

Hope this helps!

In article ,
Jeff wrote:

Hi,

I have a column of numbers with duplicates. so the numbers might be


A1 = 33, A2=1221, A3=4, A4=4, A5=4, A6=8392,....

I want to display the numbers without the duplicates - in column B.

Do you know how to do this?

Thanks for your help.