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