Example: Two columns, A and B
[TABLE="width: 151"]
<tbody>[TR]
[TD]A
bean
carrot
pea
bean
bean
apple
tomato
mango
apple
beetroot
[/TD]
[TD]B
pea
carrot
bean
beetroot
[/TD]
[/TR]
</tbody>[/TABLE]
In the above example some values in A are missing in B.
What I would like to do:
Using a formula in one cell only, look at all values in Column A to verify if they appear at least once in column B, so the answer from the formula only needs to be TRUE or FALSE.
[TABLE="width: 151"]
<tbody>[TR]
[TD]A
bean
carrot
pea
bean
bean
apple
tomato
mango
apple
beetroot
[/TD]
[TD]B
pea
carrot
bean
beetroot
[/TD]
[/TR]
</tbody>[/TABLE]
In the above example some values in A are missing in B.
What I would like to do:
Using a formula in one cell only, look at all values in Column A to verify if they appear at least once in column B, so the answer from the formula only needs to be TRUE or FALSE.
Last edited: