How many different enrties are in the column ?

[Gabor]

Is there a formula which counts how many different entries are in a specific
column or range?
It would be like when you turn on Data>Filter and you would count how many
lines are there in the dropdown window of the filter.
Gabor

 

[Electra]

enter the following into a cell

=SUM(1/COUNTIF(A123,A123))

then press : CLT SHIFT ENTER (instead of just pressing ENTER)

if you do it correctly excel will display the formula enclosed in
braces:
{=SUM(1/COUNTIF(A123,A123)}


also their can't be any blanks cells in the range. if you have blanks
in your range then you must use the following:

{=sum(if(countif(a1:d23,a1:d23)=0,"",1/countif(a1:d23,a1:d23)))}

By the way I got these formulas from a book that is really helpful:

Microsoft Office Excel 2003 Bible by John Walkenbach