Counting number of unique datafields in a column

J

johan

Hello,

Does somebody know if there is a formule which I can put into a
specific datafield and which shows me the number of unique datafields
in another compleet column.

For example;
- formula in datafield A2, which shows in this example "5", because in
column B are at this moment 5 unique values (or letters) registered.

- in column B registered field B1 till B10 with the values;
2, 2, 3, 3, 4, 4, 5, 5, 6, 6

regrds,
Johan
 
M

Mike H

Do you mean unique values in a range?

If so try this with the range changed to suit

=SUMPRODUCT((A2:A10<>"")/COUNTIF(A2:A10,A2:A10&""))

Mike
 

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

Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Excel formula for counting nr records with data and related empty fields 3
Counting unique values in multiple columns 4
Counting unique values in column 3
Finding the right style field in VBA 0
Search cell value in same column 3
Formating bolded text exclusively. 0
Return last non-blank cell in column 3

Top