Hello,

I have seen this question posted before, but cannot figure out how to input a formula that works for my spreadsheet. The data is as follows:

Column C Column D
Invoice # Employee
1701767 Michelle
1701767 Michelle
1701767 Michelle
1701768 Erica
1701768 Erica
1701769 Malori

How can I have the invoice numbers in Column C automatically populated based off of the employee name in column D? There are sometimes 3 lines per employee, sometimes just 1 line, or sometimes there are upwards of 8 lines. The formulas I have seen before usually create an invoice number for each line, instead I need a formula that keeps the same invoice number until the employee name changes in Column D.

Much appreciated!!!