Count No of Types.
Mike Sir,
Excellent solution.
Thank a lot.
H S Shastri
================================================== ======
"Mike H" wrote:
Try
=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))
Mike
"HARSHAWARDHAN. S .SHASTRI" wrote:
Hello,
Column A consisting data , what i need is count no of types in this data.
A
B
B
C
D
D
E
Y
Z
In above example answer should be "6" as B,C,DE,Y and Z are only variety
of types.
H S Shastri
================================================== ===
|