Counting

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

Guest

HOw do I count the number of unique cells whilst excluding those which have
identical values? I.e.

Col A

1234
1234
3456
4567

The number of unique numbers is 4 (as the first 2 are the same)
 
=SUMPRODUCT((A1:A20<>"")/COUNTIF(A1:A20,A1:A20&""))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

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

How do I lookup several values and concatenate the results? 1
Find and Replace with wild cards 3
index/match, based on more than one criteria 2
Help - how could I query a memo field and get one or more 4-character data ? Tough as hell for us to 3
Help needed with SELECT query 2
join worksheets 2
Help! Newbie 7
How to identify staff who has deptcode change 2

Back
Top