•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Count number of duplicates in one column based on criteria in 2 other columns
I am trying to write a formula to count the number of duplicate values in column B when column G = Yes and when column I = 1. For the formula to return a value I do need G to be Yes and I to be 1. If G is Yes and I is 2 I do not want that counted as a duplicate.
For instance if the number 7777 appeared 5 different times in column B, but Column G = Yes and Column I = 1 in 3 of them the formula would return a value of 3.
[link] [comments]
Want to read more?
Check out the full article on the original site