get count of row without duplicate entries
 

Hi,

Need help in getting the following functions in excel, i need to get a count
of values in a row, if there are duplicate values they should not be
considered, how can this be done.

Need response ASAP.

Thanks,

http://www.cpearson.com/excel/duplicat.htm#Replacing

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Aananth" wrote in message
...
Hi,

Need help in getting the following functions in excel, i need to get a
count
of values in a row, if there are duplicate values they should not be
considered, how can this be done.

Need response ASAP.

Thanks,

If you're looking for a distinct count...

=SUM(IF(A2:F2<"",1/COUNTIF(A2:F2,A2:F2)))

which you need to confirm with control+shift+enter instead of just with
enter.

If you're looking for a count of items with single-occurrence...

=SUMPRODUCT(--(COUNTIF(A2:F2,A2:F2)=1))

Aananth Wrote:
Hi,

Need help in getting the following functions in excel, i need to get a
count
of values in a row, if there are duplicate values they should not be
considered, how can this be done.

Need response ASAP.

Thanks,


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=273561