I have a Column of data that contains headers throughout ("Job #") and a large number of repetitive data points ("Cost Codes"). For example:

Column A | Column B | |

Row 1 | Job 1111 | |

Row 2 | Cost Code 1 | |

Row 3 | Cost Code 2 | |

Row 4 | Cost Code 3 | |

... | ... | |

Row 8 | Job 2222 | |

Row 9 | Cost Code 1 | |

Row 10 | Cost Code 2 |

<tbody>

</tbody>

I would like to write a formula into every cell in column A that looks for and returns the most recent Job # in column B. In the example above, cells A9 and A10 should produce "2222", where as A2:A4 should all return "1111".

Does anyone have any idea? I can not seem to think of a formula that looks bottom up.

Thank you in advance for your help,

NaityP