Infinite Updating Column
If there's nothing else numeric in the column, you can just leave off the row
qualifiers: =average(j:j)
"murphyslaw18" wrote:
How does someone write, lets say an average function to constantly update
from a column that has no definite end? Currently I am using:
=AVERAGE(J5:J35)
but this will have to constantly be changed as the J column is filled out.
|