Count function...i think

  • Thread starter Thread starter Mike P.
  • Start date Start date
M

Mike P.

Hello peeps,

i need to figure out how to count the number of items in a
list that are different.. say i have a list of number 99
lines long..but there are only a total of 20 number in the
list..some number are repeated...what function or format
can i use to search to count for just the total amount of
different number or character in a column?

EX
1234
1234
1234
2342

if i use count on the above list it will tell me 4. but i
need a function to tell me 2..because there are only 2
different numbers in that list. please help!
 
You can use the =COUNTIF function, and use it with a formula to count
specific data. One example is counting the number of times 1234 is in
your range. This would look like this: =COUNTIF(A1:A99, "1234").
Another is =COUNTIF(A1:A99,"<>1234"). this is the number of times the
cell does not equal to 1234, but it will also count the null (empty)
fields. So you have to use the formula:
=(COUNTIF(A1:A99,"<>1234")-COUNTIF(A1:A99, "")) to remove any null
field count.
 
Back
Top