•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
Tagged with
#AI formula generation techniques
#Excel alternatives for data analysis
#formula generator
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#Excel alternatives
#cloud-based spreadsheet applications
#duplicates
#count
#column B
#column G
#column I
#Yes
#formula
#criteria
#returned value
#number
#appearances