unique records

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

Guest

Is there a formula to determine the number of unique items in a columm?
 
=SUM(IF(A1:A10<>"",1/COUNTIF(A1:A10,A1:A10)))

...entered using CONTROL+SHIFT+ENTER.

Hope this helps
 
You must log in or register to reply here.

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 formulate total before Gst? 2
formula to insert a row of consective numbers in a columm (1tru 5 2
Unique records of matching pairs 2
Using (SUM(IF(FREQUENCY....to determine unique values 2
Unique Records 3
Major Help Needed Asap 7
Rows into Columms 1
calculating 3

Back
Top