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