I need help in getting excel to count the number of different number
values in a specified range of cells across a row. example:
1 1 2 should return 2
0 1 2 should return 3
2 2 2 should return 0

Can anyone help? thanks.


--
chiapas77
------------------------------------------------------------------------
chiapas77's Profile: http://www.excelforum.com/member.php...o&userid=30568
View this thread: http://www.excelforum.com/showthread...hreadid=518895

Hi,
try =SUMPRODUCT(1/COUNTIF(A1:C1,A1:C1)) if your values are in A1:C1
then fill down.
Ken Johnson
PS I think you meant 2 2 2 should return 1, if not then this is not the
solution you are after.