Ah, I understand. So, to check that the codes are exactly the same too, you would use this:
![]()
=IF(AND(LEFT(B2,5)=LEFT(B3,5),C2=C3),"SAME","CONFLICT")
Ah, I understand. So, to check that the codes are exactly the same too, you would use this:
![]()
=IF(AND(LEFT(B2,5)=LEFT(B3,5),C2=C3),"SAME","CONFLICT")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks