hello,
i have data inputting to various cells in real time, which is updated several times a second. ie cell g6, 1.9, 1.92, 1.87, 2, 2.1, 1.7 and so on.

what i need to do is, if this stream of numbers falls to or below a set number for instabce 1.9, i wish to be able to capture that number and then capture any further falls in value until it hits its lowest point, ie started at 2.2 fell to 1.89(hopefully capture, if it goes out to 3, does not matter, but if it drops to 1.5 then also capture this second number.

i thought i had it for a moment with if(g6<=1.9,g6,""), although it works, if g6 then falls lower the value changes, or if it goes higher 1.9, nothing. i need it to capture 1.9 or lower, and irrespective of any change in value, i need to capture this initial state.

hope this makes sense, any help/suggestions would be appreciated.

regards tony