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