I have a cell which represents a percentage increase or decrease of a range of cells.The cell containing the percentage is just one cell, X25. This cell is constantly changing as it's linked to betting market odds so I'm looking to find the high percentage for that one cell. When X25 decreases from it's peak, the cell Z25 needs to be showing the absolute peak percentage that X25 has reached. There is no set percentage that I'm looking to reach in Z25, I just want it to display the highest point of X25, be that 1.2%, 5.5%, 35.5% etc. What I'm trying to do is to record the peak value that this percentage reaches and have it placed in another cell.
For example cell X25 contains the percentage and starts at 0%, Over time this percentage increases to 1.2% before moving back down to 0.6%. In cell Z25 I'd like the peak value of 1.2% to be present at all times and only change if the percentage increased above 1.2%. I'm sure this is possible but I'm at a loss as to working it out.
Bookmarks