Counting Unique Vales in a column

F

frankjh19701

I have a column of numbers I need to know how many unique values there
are. Some of the numbers are just numbers, I.E. 200394840 while others
start with a letter, I.E. I200394-840. I'm not sure if the hyphen in
the middle of the number or the letter or both are throwing me off, but
I've been using =SUM(IF(FREQUENCY(A2:A772,A2:A772)>0,1)), but this seems
to only count the numbered values, not the ones that start with letters
or hyphens. Any/All help on this would be appreciated.
 
G

Guest

Try something like this:

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

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
G

Guest

=SUM(IF(FREQUENCY(MATCH(A2:A772,A2:A772,0),MATCH(A2:A772,A2:A772,0))>0,1))

ctrl+shift+enter, not just enter
 
T

T. Valko

Keep in mind, that will fail if there are empty cells. It will also count
formula blanks.

Biff
 

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

Count Unique Values in a entire column, not just range 20
Counting Unique occurences of text in a column 12
Sum one column based on the unique value in another column 2
Excel Pivot Table - Counting Unique Values within one column of da 1
Excel Counting unique values in Excel, based on criteria. 5
Counting unique text entries in a filtered list... 4
Counting unique values by date 10
Count Unique Values in 1 Column based on Date Range in another Column 28

Top