No. of different cells (numbers)

[lefty]

Hello,

I have a problem to find the way how to count different cells. Fo
example in the column below

25871
25698
42587
42365
25871
25871
25698

the result of the formul would be 4. Can anyone help me?

Thanks

 

[Dave Hawley]

Hi,

This page should help

http://www.ozgrid.com/Excel/excel-count-one-occurrence.htm

It's part of
http://www.ozgrid.com/Excel/excel-faq.htm

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Frank Kabel]

Hi
if your data is in column A try
=SUMPRODUCT(1/COUNTIF(A1:A100,A1:A100))

 

[lefty]

Frank, thank you very very much! It's working!!