Hello,
I have a Column of data that contains headers throughout ("Job #") and a large number of repetitive data points ("Cost Codes"). For example:
<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
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