Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selfreferencing ?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selfreferencing ?
Some suggestions?
Yes you could use a macro similar to below and can be linked to and event if needed to automate it Sub A1BIGGER() If Range("A1").Value Range("B1").Value Then Range("B1").Value = Range("A1").Value End If End Sub pasted into sheet Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("A1").Value Range("B1").Value Then Range("B1").Value = Range("A1").Value End If End Sub pete -- (][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][) "rvExcelNewTip" wrote in message news:rvExcelNewTip.217fsm_1136536801.0711@excelfor um-nospam.com... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selfreferencing ?
Hi pete,
http://www.mcgimpsey.com/excel/accumulator.html -- Kind regards, Niek Otten "OZDOC1050" wrote in message ... Some suggestions? Yes you could use a macro similar to below and can be linked to and event if needed to automate it Sub A1BIGGER() If Range("A1").Value Range("B1").Value Then Range("B1").Value = Range("A1").Value End If End Sub pasted into sheet Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("A1").Value Range("B1").Value Then Range("B1").Value = Range("A1").Value End If End Sub pete -- (][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][) "rvExcelNewTip" wrote in message news:rvExcelNewTip.217fsm_1136536801.0711@excelfor um-nospam.com... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selfreferencing ?
I put the original formula into the $B$1 cell and checked the Iterations option on the Calculations Tab sheet. Works Fine! I left the number of iterations unchanged as there happens to be a GoalSeek function on that particular worksheet. No noticeable performance degradation (if any). Thanks! -- rvExcelNewTip ------------------------------------------------------------------------ rvExcelNewTip's Profile: http://www.excelforum.com/member.php...o&userid=15668 View this thread: http://www.excelforum.com/showthread...hreadid=498623 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|