Help on a formula

[ForSale]

Thanks,
I hate to admit it, with that detailed description that you gave and
all, but i still can't get it. Can i possibly e-mail you the page that
i'm working on?

 

[Ron Rosenfeld]

Thanks,
I hate to admit it, with that detailed description that you gave and
all, but i still can't get it. Can i possibly e-mail you the page that
i'm working on?

OK -- but also include something that shows exactly what you want for a result;
and the logic you use to get that result.

Mail it to me at the following address, but reverse it and then change the AT
to the obvious.

moc.enilnodlefnesorTAzyx


--ron

 

[Ron Rosenfeld]

Thanks,
I hate to admit it, with that detailed description that you gave and
all, but i still can't get it. Can i possibly e-mail you the page that
i'm working on?

OK, I received your email.

Again this formula assumes that every name entry is repeated three times. So
there should be no names entered just once or twice. (That situation can be
handled, but it requires either downloading a free add-in, or adding complexity
to the formulas.

Both of the following formulas must be *array-entered* <ctrl><shift><enter>

C232:

=COUNT(TRANSPOSE(INDIRECT(ADDRESS(2+3*ROW(INDIRECT("1:75")),3))))+
COUNT(TRANSPOSE(INDIRECT(ADDRESS(3+3*ROW(INDIRECT("1:75")),3))))

C234:

=COUNT(TRANSPOSE(INDIRECT(ADDRESS(2+3*
ROW(INDIRECT("1:75")),3))))/(COUNTA(A5:A229)/3)

And I've mailed back your workbook with the formulas in place.


--ron