Counting and duplicates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calc duplicates 3
Calculating duplicates 2
Highlight duplicate cells based on a selected cell 5
Alpha sorting (with a twist...?) 3
pls. help 1
Sequential Numbering 2
Formula Question 2
how to identify duplicate rows & staffs xfr frm one depart to anot 1

Back
Top