Flag duplicates with and corresponding column matching a criteria

[Dokat]

Hi

I am trying the flag "Ration" in the output column based on 2 criteria,

1 Only duplicate values in CCP Name.

2. Corresponding Stock Type for duplicate values has to be 'Inactive - Use Up Inventory" . In below ex. i put the ration where there is duplicate values in CCP Name column and Stock type for all duplicate values is "Inactive-Use Up Inventory". Does anyone had a similar issue and formula that can solve it?

CCP Name Stock Type Output CSA11-BLK​ Inactive - Use Up Inventory CSA11-BLU​ Inactive - Use Up Inventory Ration CSA11-BLK​ Active - Use Up Inventory CSA11-BLK​ Inactive - Use Up Inventory CSAP51CS-BLK​ Inactive - Use Up Inventory CSA11-BLU​ Inactive - Use Up Inventory Ration

 

[JoeMo]

master price list.xlsm
	A	B	C
1	CCP Name	Stock Type	Output
2	CSA11-BLK	Inactive - Use Up Inventory
3	CSA11-BLU	Inactive - Use Up Inventory	Ration
4	CSA11-BLK	Active - Use Up Inventory
5	CSA11-BLK	Inactive - Use Up Inventory
6	CSAP51CS-BLK	Inactive - Use Up Inventory
7	CSA11-BLU	Inactive - Use Up Inventory	Ration
Sheet1

Cell Formulas
Range	Formula
C2:C7	C2	=IF(AND(COUNTIF($A$2:$A$7,$A2)>1,COUNTIFS($A$2:$A$7,$A2,$B$2:$B$7,"Inactive - Use Up Inventory")=COUNTIF($A$2:$A$7,$A2)),"Ration","")

 

[Dokat]

It works thank you

 

[JoeMo]

It works thank you

You are welcome - thanks for the reply.