I'm looking for a formula that will allow me to create a boolean from three columns So column E will say Yes if both "House" and "Car" are included in any order of the B:D Columns like this
| Name | Priority | Priority | Priority | Boolean in question |
|---|---|---|---|---|
| John | House | Car | Loans | Yes |
| Ned | House | Groceries | Car | Yes |
| Dom | Family | Car | Going Fast | No |
| Thanos | Stones | Balance | House | No |
| Homer | Donuts | Car | House | Yes |
How can I write a formula to create this outcome.
Aucun commentaire:
Enregistrer un commentaire