Jason Morin wrote:
Sorry...forgot about column B. B16 should be divided by
the formula I gave you, so use:
=B16/INDIRECT("M"&MAX((A16=$C$9:$C$11)*(A16<=$E$9:$E$1 1)*
{9;10;11}))
Jason
Jason,
I think I have it thanks to you but, could you explain that formula. I
understand this part of it A16=$C$9:$C$11)*(A16<=$E$9:$E$11 but I don't
see where the number in column B gets divided by M9,M10, or M11.
Everything works I just want to put the numbers in the M column on a
different hidden sheet. Also the B column has a formula in it that
refers to column D. Using the formula you gave me results in a #Value!
unless I type a number in B16
Thanks again,
David
|