Comparing five column values in a row
Solved/Closed
aman
-
Aug 15, 2011 at 08:56 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 16, 2011 at 11:43 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 16, 2011 at 11:43 AM
Related:
- Comparing five column values in a row
- Saints row 2 cheats - Guide
- How to delete a row in a table in word - Guide
- Display two columns in data validation list but return only one - Guide
- Based on the values in cells b77 ✓ - Excel Forum
- Return Seq Values Until Blank value then return different set of seq values ✓ - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 15, 2011 at 10:53 AM
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=""))
=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=""))
Aug 16, 2011 at 11:09 AM
Aug 16, 2011 at 11:43 AM