Hi guys,
What formulas should be employed to make the highlighted cells appear automatically when the figures in column C change,constantly?
(please view the attached file)
Many thanks!
Cheers.
Hi guys,
What formulas should be employed to make the highlighted cells appear automatically when the figures in column C change,constantly?
(please view the attached file)
Many thanks!
Cheers.
try min() and max() but you say constantly changing what do you mean by that?
"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
Assume the figues in Colume C will keep changing for every 15 minutes, then there will be different results. (S might not be the next Max no. and L might not be the next Min no.)
I have tried min() and max(), but it only helps to identify the numbers.
What if i wanna get the numbers and its corresponding cell like what i highlighted in the image file ?
Thanks in advance!
what happens if there is a tie for min or max?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks