Counting and duplicates

J

Jeff

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

Domenic

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!
 
Top