I am trying to record a maximum cell value in an MS Excel which is continually dynamically updated.
Note: This is not a request about using the "Max" or Maxa" functions.
My spreadsheet automatically updates with stock market data several times a second. I have a cell which calculates the value of a portfolio during the day. I would like a way of recording in another cell the maximum value that reaches during the day and another cell recording the minimum value it reaches.
Lotus 1-2-3 used to have a function that would do that.
I think some kind of macro would work, but I am not a VB programmer so I would need to have specific instructions to make it work.
Thanks,
ekrouse
Note: This is not a request about using the "Max" or Maxa" functions.
My spreadsheet automatically updates with stock market data several times a second. I have a cell which calculates the value of a portfolio during the day. I would like a way of recording in another cell the maximum value that reaches during the day and another cell recording the minimum value it reaches.
Lotus 1-2-3 used to have a function that would do that.
I think some kind of macro would work, but I am not a VB programmer so I would need to have specific instructions to make it work.
Thanks,
ekrouse