Forum Discussion
Solved
Help required - multiple formulas needed
Good day, I have the folloeing problems with an example workbook attached, that I was wondering whether anyone can help with. It involves formulas which I cannot get right/don't understand. Many ...
In B2:
=IF(COUNTIFS(Sheet2!$A$2:$A$31,A2,Sheet2!$B$2:$B$31,"banana"),"yes","no")
In C2:
=IF(COUNTIFS(Sheet2!$A$2:$A$31,A2,Sheet2!$C$2:$C$31,"vegetable")>2,"yes","no")
Fill down.
If with pre-DA Excel
=IF( ISNA( MATCH(A2&"banana", Sheet2!A:A&Sheet2!B:B, 0) ), "no", "yes")
=IF( COUNTIFS(Sheet2!A:A,A2, Sheet2!C:C, "vegetable" ) >= 3, "yes", "no" )- Thanks SergeiBaklan
The first formula doesn't seem to work all of the time, in a few instances I am getting a 'yes', rather than a 'no'.
For the 2nd formula, I am trying to count the number of instances I get a recurring label number (sheet2 d:d), providing that sheet2 c:c is a vegetable, using the same account number fopr both sheets.
I am on 365
