Hi Harlan,

Thank you very much for that amazing Formula. It works great!

Harlan Grove wrote...
Move to cell E9 in the result worksheet and change Domenic's MMULT3
defined name to refer to

=--(MMULT(--(Results=Sheet2!E$2),TRANSPOSE(COLUMN(Results)^0)) 0)

i.e., don't include a worksheet name when defining MMULT3. Excel will
refer to the active worksheet automatically.


Then change the cell E9 array formula to

E9:
=CHOOSE(2+SIGN(ROWS(E$9:E9)-SUM(MMULT3)),SUM(LARGE(IF(MMULT3,ROW(Results)),
{0;1}+ROWS(E$9:E9))*{1;-1})-1,MATCH(1,MMULT3,0)-1,"")


Cheers,
Sam


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200510/1