Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions |