Auto assign number with +1 If meet the condition given

[bobby786]

Hi all experts ,

i have workbook in which i need to maintain the orders and producer of the product.

My Goal:
COL C Producer ( if its new product and not enter before in the above COL , then it should auto assign Invoice number in D6,D7,D8 as "ORD#1" , if its 2nd time then "ORD#2" , 3rd time "ORD#3" )
For Example :
Product1 = Ord#1
Product2= Ord#1
Prodcut1= Ord#2
Product2=Ord#2
Product3=Ord#1

purpose is to track that particular order with invoice , as same product ordered in different times will carry different details in the other area of the sheet so i need to assign a unique number to be able to identify them in later stages . If i explain it poorly please do let me know i will try my best again.

PS: English is not my native language , but i use it everyday

BOOK_2020 - 2 - Copy.xlsm
	C	D	E	F
6	JF Sonic	ORD#1	500	A800
7	JF Sonic	ORD#2	1000	A800
8	Longzhen	ORD#1	5000	S30
9	Longzhen	ORD#2	4000	S30
10	JF Sonic	ORD#3	1000	A800
11	JF Sonic	ORD#4	1000	A800
12	Guiyang CB	ORD#1	500	A800
13	Longzhen	1	500	A800
CENTRAL

Cells with Data Validation
Cell	Allow	Criteria
C6:F13	Any value

 

[bobby786]

Oh. That was silly mistake from my side.
Thank you. @Fluff

 

[Fluff]

You're welcome.