Comparing five column values in a row

Solved/Closed
aman - Aug 15, 2011 at 08:56 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 16, 2011 at 11:43 AM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Aug 15, 2011 at 10:53 AM
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=""))
0
Thanks a lot ..It worked exactly the way I wanted..
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Aug 16, 2011 at 11:43 AM
You are welcome
0