Sequential No Series based on corresponding data (ie PO number)

[KatherineK]

Trying to generate a formula to add a "Line Number" for each item which relates to a specific Purchase Order Number in another column.

ie; Order # AAA has 5 lines - line 1 Line No = 10000, line 2 = 20000, line 3 = 30000, line 4 = 40000, line 5 = 50000

Order # BBB has 1 line - line 1 Line No = 10000

each new order no would begin back at Line No 10000

Sample Data attached.

[#2 · Accepted solution]

@KatherineK 

Please try this and let me know if this is what you were trying to achieve.

In B2

=COUNTIF(A$2:A2,A2)*10000

and then copy it down.

[#3]

Awesome, that worked perfectly! @Subodh_Tiwari_sktneer 

[#4]

@KatherineK 

You're welcome! Glad it worked as desired.