•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
Our take
To count the number of duplicates in column B based on specific criteria in columns G and I, you'll need a formula that emphasizes the conditions you’ve set. The goal is to identify how many times a value appears in column B when column G equals "Yes" and column I equals 1. For example, if the number 7777 occurs five times in column B, but only three instances meet both criteria, the formula should return the value of 3.
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]
Read on the original site
Open the publisher's page for the full experience
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