LinkBack URL
About LinkBacks
but it doesnt recalculate???? unless you specify the whole range
but it doesnt recalculate???? unless you specify the whole range
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
It does seem to recalculate correctly in my workbook. However to check, i think it's better to change the value in A3 instead of A2. Because the corresponding value in B2 (5) is the biggest in range B1:B5, the conditions implied in the formula leave the results in C1, C3, C4, C5 unchanged, as they should i think.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks