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
One way:
=SUM(--(A2=C2),--(B2=D2))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks