Forum Discussion

Dfuhrman8's avatar
Dfuhrman8
Copper Contributor
Jul 01, 2022
Solved

Excel Formula Help

I have a report that Column C is Invoice Number and then for Column D, is Line Number. Line Number could be 1 or 2, depending on if Column C Invoice Number is listed multiple times.

Example would :

Row 1 - Column C has invoice number: 7104

Row 2 - Column C has invoice number: 7122

Row 3 - Column C has invoice number: 7122

Row 4 - Column C has invoice number: 7123

Row 5 - Column C has invoice number: 7125

 

So Column D would need to be:

Row 1 - 1

Row 2 - 1

Row 3 - 2

Row 4 - 1

Row 5 - 1

 

Is there a Countif formula or a vba script that I could use to populate Column D based on Column C?

Thank you!

Resources