Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Axis Options - Minimum and Maximum Values | Charts and Charting in Excel | |||
Graphing the maximum and minimum values | Charts and Charting in Excel | |||
Formula with minimum & maximum values | Excel Worksheet Functions | |||
Spinners - minimum and maximum | Excel Discussion (Misc queries) | |||
Maximum & Minimum values in a coulmn | Excel Discussion (Misc queries) |