Shifting online data comes to excel to be shifted to adjacent cells as per formula with very minim

[saj]

I have one excel sheet, one particular column datas are varying by
some other controls. There may be a variation for 5 to 10 seconds
in the data . From that variations I have to find the minimum
reading in particular column and maximum reading and current reading
also.

I will put this same question in another format also again ::
In excel sheet a column contains 150 cells and in each cell the data
changes 2 to 30 times per second. We have to find out the maximum
value, minimum value and current value of that fluctuating data from
each cell and put it separately in adjacent columns(cells). Please
note that each cell is independent and there should not be any time
delay in this calculations because data flows online from a server. So
each cell data should be monitored independently updated instantly
for their minimum and maximum and current values in nearby cells
with out time delay. Here the problem to be solved is how to avoid
the time delay is the main question. Point to be noted is there are
about 1 50 cells and each cell has no connection in the data with
other cell. Each cell is totally independent and the online data
flowing in each cell has no connection to the other cell and each
cells online data should be updated instantly without time delay for
their minimum, maximum, and current values in the adjacent cells. I
could do this with time delay of 1 to 2 seconds, but the problem to be
solved is how to minimise the time delay to the maximum or avoid the
time delay totally.

 

[Guest]

Don't know how the data is being written, but it seems you need an automated
method of adding a time stamp whenever data is written. either the program
that writes the data need to add the time or the excel spreadsheet need to
add the time. One method is to write a worksheet_change function so that a
time stamp is added to each data entry automatically. Then if the data is
mved to the min or max column the time is also copied.