Hi, all!
I’m facing a challenge to do the following:
Column A with multiple choices (All, Sheep, Goats… up to 12 more)
Column B with multiple choices (Universal, Black, White)
Column C with single choice (F, SE)
Column D with multiple choices (3 mont...
The formula I used for the certain case. As Julian suggested I combined AND and OR with FIND.
SO here is the formula:
IF(
AND(
OR(FIND(
'All',
{Column A}
),
FIND(
'Sheep',
{Column A}
...
Julian, you are great! :slightly_smiling_face:
It works like a charm.
Could as well suggest how to structure IF functions as I want in column E to put multiple checks for true and false?
As I said earlier I need to write the formula for 77 such fil...
Hi, Julian!
Thank you very much for your suggestion!
Actually there are a lot of combinations between these 12 items in Column A, so I don’t think this is applicable.
Do you have any other suggestions?
