Count Non Duplicate Values with matching criteria in another column

[Dokat]

Hi,

I have a range where I am trying to count only unique values with matching criteria in cell C.. In below examples I am trying to get the unique count in column A where C is "Inactive - Use Up Inventory" and column D is "Keep".The result should be 1 as GSF11-BLK is only unique value in column A where Column C is " Inactive - Use Up Inventory" and column D is "Keep". I tried array formulas as well as row unique filter formula however wasn't able to get the result. Did anyone come across a similar issue and have a solution for it?

A	C	D
GSF11-BLK	Inactive - Use Up Inventory	Keep
GSF11-BLU	Active-Purchased Item	Keep
GSFG11-BLK	Active-Purchased Item	Keep
GSM11-BLU	Active-Purchased Item	Keep
GSFG11-RED	Active-Purchased Item	Keep
GSM11-BLK	Active-Purchased Item	Keep
GSM11-BLK	Inactive - Use Up Inventory	Keep
GSM11-BLK	Active-Purchased Item	Keep
GSM11-BLU	Inactive - Use Up Inventory	Keep
GSM11-BLU	Inactive - Use Up Inventory	Keep

 

[Dokat]

Is there any way to flag items that met the criteria above in column E? For Ex: Any item that meets the criteria above flagged as 999 in the corresponding cell in column e?

 

[Fluff]

How about

=AND(COUNTIFS($A$2:$A$11,A2)=1,C2="Inactive - Use Up Inventory",D2="Keep")

 

[Dokat]

Thanks

 

[Fluff]

My pleasure.