Dear Excel experts,
Looking for a solution for evaluation of concordance between 1st & 2nd values compared with 3rd & 4th value
1st 2nd 3rd 4th concordance
3D 3D 3D 3D 2
3D 3D 4D 3D 1
4D 3D 3D 3D 1
4D 4D 4D 4D 2
3D 3D 4D 4D 0
These are some of the solution i tried,
=OR(C2=A2,C2=B2)+AND(C2<>D2,OR(D2=A2,D2=B2))
=OR(A2=C2,A2=D2)+OR(B2=C2,B2=D2)
but it doesnt work on all cases, specially the 2nd and 3rd column.
Please help
Thanks
Bookmarks