Hi,
I am getting second to second data in excel workbook. I want to record this data in another cell. The changing values keeps on going higher high or lower lows. I want highest high in one cell and lowest low in another cell. For example suppose changing value is now 15954. It keeps on changing second to second. Suppose at next second it could be 15956 or 15950. I wanted to record made if lower than previous value in one cell. And also wanted to record if it made new high than previous value in another cell.
Bookmarks