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 (E-Mail Removed)> wrote in message
news:38E45A9D-D42E-4108-88F5-(E-Mail Removed)...
>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 (E-Mail Removed)> wrote in message
> news:38E45A9D-D42E-4108-88F5-(E-Mail Removed)...
> >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
>
>
>