I have a chart- 100 rows and 10 columns Each row has random assigned letters.
Example: jnbehuomws. I want to know how many rows m and h. I need a formula
.. Thanks Mike

Do you want to count a row if it contains duplicates:

jnbehuomws = 1 h, 1 m
hnbehuomws = 2 h, 1 m
jnbehuomms = 1 h, 2 m

Based on the above samples what result would you expect?

Biff

"ekim notpmah" <ekim wrote in message
...
I have a chart- 100 rows and 10 columns Each row has random assigned
letters.
Example: jnbehuomws. I want to know how many rows m and h. I need a
formula
. Thanks Mike

There are no duplicates.

"T. Valko" wrote:

Do you want to count a row if it contains duplicates:

jnbehuomws = 1 h, 1 m
hnbehuomws = 2 h, 1 m
jnbehuomms = 1 h, 2 m

Based on the above samples what result would you expect?

Biff

"ekim notpmah" <ekim wrote in message
...
I have a chart- 100 rows and 10 columns Each row has random assigned
letters.
Example: jnbehuomws. I want to know how many rows m and h. I need a
formula
. Thanks Mike