Good afternoon,
I am struggling trying to compare 4 Cells that should contain either 4*1 or 4*2 or 4*3.
The target is, to find in Cell A1:A4, either only 1s or either only 2s or either only 3s and if so, then it is True and if not, it is False.
If I use the formula:
=AND(EXACT(A1:A4,B2))
it works but I have no clue, how to extend it, so I also can check for value 2 or 3? Or maybe with match but here also stuck.
Can you please help?
Thank you,
Mike
Bookmarks