Thanx Dave,
It worked perfectly.
Maddoktor
"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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)))
>
>
>
> Maddoktor wrote:
>>
>> 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.
>>
>> "Dave Peterson" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > 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))
>> >
>> >
>> >
>> > Maddoktor wrote:
>> >>
>> >> 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
>> >
>> > --
>> >
>> > Dave Peterson
>
> --
>
> Dave Peterson
|
Similar Threads
