Workbook is sent over by the customer so that we can enter their orders into our system. When they send over the file with multiple orders/items, I need to be able to add a line number to each row. Line numbers are sequential based on the PO Number where a new PO number would restart the sequence.
Basic structure (unnecessary data omitted) and expected result in Column B:
Column A | Column B
PO NUMBER | LINE NUMBER
ABC123 | 1
ABC123 | 2
DEF456 | 1
DEF456 | 2
DEF456 | 3
GHI789 | 1
Any thoughts on how to do this would be appreciated. Thank you!
Basic structure (unnecessary data omitted) and expected result in Column B:
Column A | Column B
PO NUMBER | LINE NUMBER
ABC123 | 1
ABC123 | 2
DEF456 | 1
DEF456 | 2
DEF456 | 3
GHI789 | 1
Any thoughts on how to do this would be appreciated. Thank you!