How to count text values from a row having multiple text, numerical values & blanks?

[Paulo]

Hi,
I have to generate the count of number of text values, from a row which has blanks, numerics and unique as well as repeated text values. (Pls ref attached sample file).

Not feasible using a =countif(), because the organization names keep adding everyday and the number of names.

Issue is, this particular data comes with other data validations (which is not relevant here).

The end result I need is - Number of organizations that a customer has taken a loan from.

I tried using various combinations and has come up with a Sumproduct, but this too does not solve the purpose (has used this in the attached excel).

Please help.

 

[Mike H..]

Hi,
I have to generate the count of number of text values, from a row which has blanks, numerics and unique as well as repeated text values. (Pls ref attached sample file).

Not feasible using a =countif(), because the organization names keep adding everyday and the number of names.

Issue is, this particular data comes with other data validations (which is not relevant here).

The end result I need is - Number of organizations that a customer has taken a loan from.

I tried using various combinations and has come up with a Sumproduct, but this too does not solve the purpose (has used this in the attached excel).

Please help.

Hi,

I'm not really sure I fully understand this but have a look at your workbook, my formula are in Column A.

 

[Paulo]

Hi,

I'm not really sure I fully understand this but have a look at your workbook, my formula are in Column A.

Hi Mike,
It's just perfect. Your formula works fine for me.
Sorry not to have conveyed the message correctly in the post. Found it difficult to express here.

Thanks a ton!
A special thanks for the super fast reply.

Cheers,
Benoy.