RunningMax



Cell B1 will contian the highest value that has ever been present in A1:A10, even if that value is deleted from the range.


 * Use the =MIN function to get the lowest ever value.