Hi, In my Excel file, column 'V' has data from a process and the value peaks to around 6.0 at multiple times, during the process. The time corresponding to each data point is captured in a separate column 'C'. I would consider all values between 5.5 and 6.0 as the peak. Some time the peak value is maintained for 2 hours before dropping down to <5.5. At other times, it can be up for 6 hours.
I am interested in finding out the 'Maximum duration' over which the peak value (5.5-6.0) was maintained.
I am not much used to VBA, so a formula would be great. Otherwise, I'd appreciate if you can write the VBA code which I paste in the macro box and run it, please.
Thanks
I am interested in finding out the 'Maximum duration' over which the peak value (5.5-6.0) was maintained.
I am not much used to VBA, so a formula would be great. Otherwise, I'd appreciate if you can write the VBA code which I paste in the macro box and run it, please.
Thanks