Hi,

Try this

=SUM(IF(FREQUENCY(A1:A100,A1:A100)0,1))

Mike

"ldiaz" wrote:


I have a column [PO#], I want to count how many different values are on that
column to get as result =3, can you please help me on that?

example
PO#
10210
10210
10211
10211
10211
10212

Thanks
LD

--
Lorenzo DÃ*az
Cad Technician