Find the max value of one constantly changing cell

**Consty1** · 10-15-2012, 10:16 AM

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.

**twiggywales** · 10-15-2012, 10:19 AM

i think you would need a macro actually,

which is above my current level of skill to be honest.

i think something with a counter that remains constant, and a work sheet activated update

**TMS** · 10-15-2012, 10:21 AM

I think you'd need to use a VBA Change event to monitor one or more cells. If X25 is a formula, changes will not be triggered by the change(s) in the formula's value, rather the cells that X25 is dependent on. So, when one of those cells changes, then the current value would be checked against the "highest" value and, if it is greater, replace it.

But it needs VBA (IMO) and we'd need to know the formula in X25.

Regards, TMS