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?
|