Dear all,
I hope everyone is well. I am given a price range daily and I wanted to know what formula I can use to get the daily high and low from each range daily.
I have attached a screenshot. The desired output is in yellow
TIA
I hope everyone is well. I am given a price range daily and I wanted to know what formula I can use to get the daily high and low from each range daily.
I have attached a screenshot. The desired output is in yellow
TIA
Attachments

25.7 KB Views: 32