How to check for and replace the largest number in excel

N

Navigation Man

In Excel 2003 how do you check two cell for the largest numnber, then
replace the existing one if true, without invoking the circular referance
error.

for cell a2 if (a2>a3,A2,a3)
 
B

Biff

Hi!

A2 would have to start out as an empty cell.

Goto Tools>Options>Calculation
Check Iteration

Then enter this formula in A2:

=MAX(A2,A3)

NB: there is no "audit trail" to follow, so if you make a
mistake..............you enter 1000 in A3 when you meant to enter 100.

You'd probably be better off using an event change macro that records the
value every time it changes in cell A3. Then you'd have an audit trail.

Biff
 
Top