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

================================================== ===

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

================================================== ===

Sir i am getting the results but unable to understand the logic behind
formula . Will you pl elaborate the formula.

Thanks in advance.

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

================================================== ===

One way is to get the unique list and then count them.
To get unique list do as follows:
Data| Filter| Advanced filter
In action select: copy to another location
Select the List range (or it is selected automatically)
Put a reference cell for: copy to range
tick: Unique records only
Then you get the number by a count function
--
R. Khoshravan
Please click "Yes" if it is helpful.


"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

================================================== ===