Forum Discussion
Question about matching multiple rows
Hi everyone, I'm working on an Excel dataset and looking for a proper function to generate a summarizing column. Here's the raw data format: I want to get a summary table like this: ...
Hello Janice,
Apple is available in supermarket or grocery. In the attached file, the formula in G2, copied down to G5, is:
=CHOOSE(1+(COUNTIFS(B$2:B$12,F2,C$2:C$12,"yes")>0)+(COUNTIFS(B$2:B$12,F2,D$2:D$12,"yes")>0),
"nowhere",
IF(COUNTIFS(B$2:B$12,F2,C$2:C$12,"yes"),"supermarket","grocery"),
"supermarket or grocery")