Respected Members,
I have attached a file below, please check,
In Calculation Sheet, I wanted to obtain the Highest High in "I" & Lowest low in "J" columns from the constantly changing cell value "G" .
Also i would like to know what are the various formulas for capturing HH & LL form a single dynamic cell. I got the reference for the same " https://chandoo.org/forum/threads/to-capture-highest-and-lowest-value.20669/ " but unfortunately this has much older version of excel, i couldn't see any formulas to take the benefit. My version of Office Excel is 2019.
Thank you,
kopsy
I have attached a file below, please check,
In Calculation Sheet, I wanted to obtain the Highest High in "I" & Lowest low in "J" columns from the constantly changing cell value "G" .
Also i would like to know what are the various formulas for capturing HH & LL form a single dynamic cell. I got the reference for the same " https://chandoo.org/forum/threads/to-capture-highest-and-lowest-value.20669/ " but unfortunately this has much older version of excel, i couldn't see any formulas to take the benefit. My version of Office Excel is 2019.
Thank you,
kopsy