Help on a formula
 

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?


--
ForSale
------------------------------------------------------------------------
ForSale's Profile: http://www.excelforum.com/member.php...o&userid=11896
View this thread: http://www.excelforum.com/showthread...hreadid=277223

On Thu, 11 Nov 2004 16:28:10 -0600, ForSale
wrote:


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

On Thu, 11 Nov 2004 16:28:10 -0600, ForSale
wrote:


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