Capturing Maximum and Minimum values
 

Hi

Lets sy I have a cell that sums a range of cells.

b11 is =sum(b1:b10)

Let's say I have a condition where the sum will periodically change,
because some cells above will either have a value, or not have a value
as time goes by, or the values change, which will on any given revision
of the data in b1:b10 change the bottom line sum in b11.

What I want to do is be able to capture in another field what the
maximum sum, and minimum sums were.

For example:

on 12/3 the sum in b11 was 1000
on 12/4 the sum in b11 was 5000
on 12/6 the sum in b11 is 2500


So as of 12/6, the MAX sum was 5000 and the MIN was 1000. Is there a
simple way to keep a record of what had been transpiring in b11 so I
can know what the MAX and MIN was?

Thx


--
tx12345
------------------------------------------------------------------------
tx12345's Profile: http://www.excelforum.com/member.php...o&userid=24776
View this thread: http://www.excelforum.com/showthread...hreadid=490857

Capturing Maximum and Minimum values
 

Try selecting the Iteration check box through Tools Options Calculation
tab. This will suppress the circular reference problem. Example:

A6 contains the formula:
=Sum(A1:A5)
B6 contains the formula:
=Max(A6, B6)
Then B6 will record the max value it sees in A6 which is the max of values
entered into A1:A5.

Regards,
Greg


"tx12345" wrote:


Hi

Lets sy I have a cell that sums a range of cells.

b11 is =sum(b1:b10)

Let's say I have a condition where the sum will periodically change,
because some cells above will either have a value, or not have a value
as time goes by, or the values change, which will on any given revision
of the data in b1:b10 change the bottom line sum in b11.

What I want to do is be able to capture in another field what the
maximum sum, and minimum sums were.

For example:

on 12/3 the sum in b11 was 1000
on 12/4 the sum in b11 was 5000
on 12/6 the sum in b11 is 2500


So as of 12/6, the MAX sum was 5000 and the MIN was 1000. Is there a
simple way to keep a record of what had been transpiring in b11 so I
can know what the MAX and MIN was?

Thx


--
tx12345
------------------------------------------------------------------------
tx12345's Profile: http://www.excelforum.com/member.php...o&userid=24776
View this thread: http://www.excelforum.com/showthread...hreadid=490857