Live Update Sheet

[Techtrend]

Hi Friends

I am making a Live update sheet,The sample is attached with description,

I have problem in capturing Highest and lowest value from the same Column

But I want result dynamically. Please help me to achive it,

Thanks alot in Advance
Satish

 

[Hui]

Satish

Firstly, Welcome to the Chandoo.org Forums

In I2: =IF(ROUND(C2,2)=ROUND(E2,2),E2,"")
Copy down

I'm not sure about Columns J & K

Please explain what they should do

 

[Techtrend]

Thanks for the quick turnaround time and yes your logic works fine,

The 2nd issue is

The H column is open interest will be dynamic and the value keeps changing as the sheet is updated live for Ex currently the H2 value is 79000 if the value increases to 82000 in H2 col the value in column J increases to 82000 capturing the highest value and from there if the value drops to 74000 in H2 column the lowest value has to capture in k2,Now the k2 value will change from 75000 to 74000 which is the lowest

Let me know if i am clear or needs further clarification
Narendra Kumar

 

[Somendra Misra]

Hi Narendra,

I don't think Excel formula's can store past values occurring in a cell. May be VBA will be needed for the same.

Regards,

 

[Techtrend]

Can any one fix this either with a Conditional formula or as mentioned through VBA