I face an easy question and possibly a complicated solution: A data
variable is captured daily and entered into a spreadsheet cell ($A$1).
I want cell $B$1 to list the highest value every entered into cell $A$1.
The value in cell $A$1 does not need to be preserved (it is overwritten
the next day by the new measurement)

If cell $B$1 could contain the following formule, the solution would be
easy:
-=if($A$1$B$1,$A$1,$B$1)-
but Excel doesn't allow selfreferencing., so that was a nice dream.

Some suggestions?


--
rvExcelNewTip
------------------------------------------------------------------------
rvExcelNewTip's Profile: http://www.excelforum.com/member.php...o&userid=15668
View this thread: http://www.excelforum.com/showthread...hreadid=498623