[INDENT]Hi,
I have a row which has alteranate numbers and text through out the row. But using the below formula for the range which has both text and numbers, gives me the unique total count of numbers+text.
=SUMPRODUCT((D4:CK4<>"")/COUNTIF(D4:CK4,D4:CK4&""))
Can you please suggest a formula to help me count only the unique numbers in the row ,without the text being included.
Thanks in advance. [/INDENT]