I am looking for a formula for column C to autofill the information from the
cell directly above BASED on data in Column B -- ie If cell B4 has data than
cell c4 will auto fill with the data in cell c3. if there is no info in the
correlating cell in column B the cell in column C will remain empty.

DEPART ARRIVE
ICAO ICAO PIC
KDPA KMDW GFA
KMDW KPBI
KPBI KDPA
KDPA


THANKS in advance -- JB

On Oct 14, 8:02*am, JB Bates
wrote:
I am looking for a formula for column C to autofill the information from the
cell directly above BASED on data in Column B -- ie If cell B4 has data than
cell c4 will auto fill with the data in cell c3. *if there is no info in the
correlating cell in column B the cell in column C will remain empty.

DEPART * * * * *ARRIVE * * * * * * * * *
ICAO * * * * * *ICAO * * * * * *PIC * *
KDPA * * * * * *KMDW * * * * * *GFA
KMDW * * * * * *KPBI
KPBI * * * * * *KDPA
KDPA * *

THANKS in advance -- JB * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

enter in C4 ....=IF(B4="","",C3)

this will do what you asked for, for one line, but
if you do enter names into the C column cells you will
loose the formula.............
you may have to setup your sheet differently.
greetings from New Zealand

In C4 enter this formula
=IF(B4<"",C3,"")
Fill down as required. But if I have read and understood correctly, that's
going to put GFA into column C on any row where there's an entry in column B.
So C4 and C5 will also contain GFA, with C6 remaining empty.


"JB Bates" wrote:


I am looking for a formula for column C to autofill the information from the
cell directly above BASED on data in Column B -- ie If cell B4 has data than
cell c4 will auto fill with the data in cell c3. if there is no info in the
correlating cell in column B the cell in column C will remain empty.

DEPART ARRIVE
ICAO ICAO PIC
KDPA KMDW GFA
KMDW KPBI
KPBI KDPA
KDPA


THANKS in advance -- JB

Hi Bill - thanks for the help. if there is no data in C3 it is giving me
"0.0" in C4 -- is there a way around this? JB

"bill kuunders" wrote:

On Oct 14, 8:02 am, JB Bates
wrote:
I am looking for a formula for column C to autofill the information from the
cell directly above BASED on data in Column B -- ie If cell B4 has data than
cell c4 will auto fill with the data in cell c3. if there is no info in the
correlating cell in column B the cell in column C will remain empty.

DEPART ARRIVE
ICAO ICAO PIC
KDPA KMDW GFA
KMDW KPBI
KPBI KDPA
KDPA

THANKS in advance -- JB

enter in C4 ....=IF(B4="","",C3)

this will do what you asked for, for one line, but
if you do enter names into the C column cells you will
loose the formula.............
you may have to setup your sheet differently.
greetings from New Zealand

Hi - thanks for the help. if there is no data in C3 it is giving me "0.0" in
C4 -- is there a way around this? JB

"JLatham" wrote:

In C4 enter this formula
=IF(B4<"",C3,"")
Fill down as required. But if I have read and understood correctly, that's
going to put GFA into column C on any row where there's an entry in column B.
So C4 and C5 will also contain GFA, with C6 remaining empty.


"JB Bates" wrote:


I am looking for a formula for column C to autofill the information from the
cell directly above BASED on data in Column B -- ie If cell B4 has data than
cell c4 will auto fill with the data in cell c3. if there is no info in the
correlating cell in column B the cell in column C will remain empty.

DEPART ARRIVE
ICAO ICAO PIC
KDPA KMDW GFA
KMDW KPBI
KPBI KDPA
KDPA


THANKS in advance -- JB