Thank you Jonmo1 that's great!

I was trying with IF, AND and OR functions but didn't consider your solution with COUNTIFS, which seems very neat and works very well! Thank you!

I do have one question about how the formula is working if that's ok?

For instance if I have an ID with two "apple" entries and no "banana", giving an array {2,0} how does that change to {TRUE,FALSE}?

I get that the double dash changes it from {TRUE,FALSE} to {1,0}.

Thank you