I need to track the High and Low of some variables generated from my stock quote service and the RTD links from an Excel Add-in. I hope to do so using formulas and functions rather than VBA. I was thinking of something like this. The value is located in cell B1. In D1 I would have a formula that tests if B1 has increased then record the new value, if not then leave D1 the same. Appreciate the help!!
Bookmarks