Automatically update cells

M

Maddoktor

Hi all,

I am looking for help with the following problem.

I would like for two cells to automatically update every time I fill in
other cells.

For example:

Cell A1 is the date cell
Cell B1 is the weight cell

In column F, I have every date for a month and in column G, I insert a
weight

I would like for cell A1 to automatically update with the date from column F
and cell B1 to automatically update with the weight every time I enter a
weight into column G.

For example:

If column F has every date for a particular month, i.e. 1/3/06 in cell F1
and I enter 50.0 in cell G1, then cell A1 will reflect F1 (1/3/06) and B1
will reflect G1 (50.0). But when I enter 75.0 in cell G2 for the weight, I
would like for cell A1 to automatically update to 2/3/06 (F2) and cell B1 to
update to 75.0.

Is this possible.

Thanx in advance.

Maddoktor
 
D

Dave Peterson

IF you don't have any gaps in those columns (F and G), you could use a formula
like:

=INDEX(G:G,COUNTA(G:G))
or
=INDEX(F:F,COUNTA(F:F))
 
M

Maddoktor

Thanx Dave,

It worked as I hoped for.

I would like to slightly modify the formula so that I could start at cells
F7 and G7. I tried modifying the formula myself but I get #VALUE! error with
the modified formula of:

=INDEX(F$17:F$65536,COUNTA(F$17:F$65536))

Looking forward to the solution.
 
D

Dave Peterson

But once you put something in F17:f65536, it worked fine, right?

You could just check to see if something there's first:

=IF(COUNTA(F$17:F$65536)=0,"",INDEX(F$17:F$65536,COUNTA(F$17:F$65536)))
 
M

Maddoktor

Thanx Dave,

It worked perfectly.

Maddoktor



Dave Peterson said:
But once you put something in F17:f65536, it worked fine, right?

You could just check to see if something there's first:

=IF(COUNTA(F$17:F$65536)=0,"",INDEX(F$17:F$65536,COUNTA(F$17:F$65536)))
Click to expand...
 
Top