Comparing five column values in a row

[Solved/Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hi All,
I am new to office excel and need your expert help to resolve one issue:

I have five columns in different rows with values and I need to compare all the five columns values.If all five are not same then I want to print TRUE otherwise it should print FALSE. if any of the column has the value as " NOT " then that cell should be ignored while doing the comparison.
for example ,
1 1 1 1 1 should return TRUE as result
1 1 NOT 1 1 should return TRUE as result
1 1 1 2 1 should return FALSE as result
1 1 NOT 2 1 should return FALSE as result.

Thanks in advance for your help..



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you can try some thing like this


=AND(OR(A1=B1,A1="",B1=""),OR(B1=C1,B1="", C1=""), OR(C1=D1, C1="", D1=""), OR(D1=E1, D1="", E1=""),OR(E1=A1, E1="", A1=""))
Thanks a lot ..It worked exactly the way I wanted..
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You are welcome