Forum Discussion
Need Formula: IF (CELL1 or CELL2) = (CELL3 or CELL 4) then TRUE.
Hello! I'm just getting my feet wet with formulas in Excel and I think I need a nested IF/OR formula. Basically I want to compare two sets of cells. If there are any matches between the cells, I ...
Hi, to all!
Another options could be:
=OR(A1=A2, A1=A3, A2=A3, A3=A4)
=SUMPRODUCT(COUNTIF(A1:A2,A3:A4))>0
=OR(A1:A2=TRANSPOSE(A3:A4)) <-- Array Formula (Ctrl + Shift + Enter)
Blessings!