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?

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?