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
Re: Get the Maximum Value and its corresponding cell
Max and min functions for column C.
INDEX & MATCH functions for column B
Re: Get the Maximum Value and its corresponding cell
Fotis1991, can you please further explain the workout?
Re: Get the Maximum Value and its corresponding cell
Can you pls upload a small sample workbook and not a picture?
Re: Get the Maximum Value and its corresponding cell
Sure, attached pls find the excel sample.
Tq
Re: Get the Maximum Value and its corresponding cell
=max(c1:c20)
=index(b1:b20;match(b24;c1:c20;0))
Re: Get the Maximum Value and its corresponding cell
Thanks Fotis1991, it works
Re: Get the Maximum Value and its corresponding cell
You are welcome! Thanks for the feedback!
Don’t have an account yet? Register yourself now and be a part of our community!