close
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: www.excelforum.com/member.php...oamp;userid=30568
View this thread: www.excelforum.com/showthread...hreadid=518895Hi,
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.
全站熱搜
留言列表
