• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Countly Only Unique rows with matching criteria in another column



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" The result should only 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 I am looking for. Did anyone come across a similar issue and have a solution for it?

GSF11-BLKInactive - Use Up InventoryKeep
GSF11-BLUActive-Purchased ItemKeep
GSFG11-BLKActive-Purchased ItemKeep
GSM11-BLUActive-Purchased ItemKeep
GSFG11-REDActive-Purchased ItemKeep
GSM11-BLKActive-Purchased ItemKeep
GSM11-BLKInactive - Use Up InventoryKeep
GSM11-BLKActive-Purchased ItemKeep
GSM11-BLUInactive - Use Up InventoryKeep
GSM11-BLUInactive - Use Up InventoryKeep