Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Update Log
Hi: I want to creat a log like this:
ColB Col C R65 12/1/04 $number R66 12/2/04 $number Where each day I want to add today's new date and the number. The number is the minimum value of a row of numbers in row 52. Often, however, row 52 changes because of additions/deletions. Any ideas? |
#2
|
|||
|
|||
Minimum value: =MIN(52:52)
If you're trying to keep a row reference from changing even if rows are deleted, you can try something like; =MIN(INDIRECT("52:52")) "WayneB" wrote in message ... Hi: I want to creat a log like this: ColB Col C R65 12/1/04 $number R66 12/2/04 $number Where each day I want to add today's new date and the number. The number is the minimum value of a row of numbers in row 52. Often, however, row 52 changes because of additions/deletions. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update linked cells within a workbook??? | Links and Linking in Excel | |||
Update Individual Links | Excel Discussion (Misc queries) | |||
2003 update link when Source open | Excel Worksheet Functions | |||
Linked values turn to #REF! after clicking don't update | Excel Worksheet Functions | |||
auto update | Excel Worksheet Functions |