I took an array formula that I've seen used for getting unique numbers and
made a slight change to it so that if there was only one unique item, it
would return 0. Worked on your test data.

=IF(SUM(1/COUNTIF(A2:C2,A2:C2))=1,0,SUM(1/COUNTIF(A2:C2,A2:C2)))

Enter with cntl-shift-enter, not just enter.
--
Kevin Vaughn


"chiapas77" wrote:


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=518894