Capture Highest & Lowest Value

[hsandeep]

B2 gets updated by values due RTD
B3 I have kept a flag which becomes 1 for a certain time period (ONLY ONCE DURING A DAY)
Solution required:
B4=HIGHEST VALUE of B2 when B3=1 else 0
B5= LOWEST VALUE of B2 when B3=1 else 0
How to accomplish?
Thanks in adv

 

[jasonb75]

If I understand what you want correctly then this should do what you need.

First go to options in the excel File menu, on the Formulas tab check the box that says 'Enable iterative calculation' and click OK.

In B4, =IF(B3=1,IF(B4=0,B2,MIN(B4,B2)),0)
In B5, =IF(B3=1,IF(B4=0,B2,MAX(B4,B2)),0)

 

[hsandeep]

Code be given to work out the solution

 

[jasonb75]

Don't think that the iterations will work correctly with vba.

 

[hsandeep]

I want precision & not going to make my Excel adjust with iteration

 

[jasonb75]

Have you tried it?

Using code (if it works) will not be any more precise.

 

[hsandeep]

I tried but couldn't find the correct answer so approached this site

 

[jasonb75]

I meant have you tried what I suggested?

That is more likely to work correctly than vba!

 

[hsandeep]

Someone can use helpful columns or rows to achieve the result. Note the flaf remains for 30 minutes sharp when started

 

[hsandeep]

Can someone give me code I can 'Put a cap' on the Max Value at 1000 & Minimum Value at 1