• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Check error

kaushik03

Member
Hi All,


I want to catch errors for the following scenarios:


If same name assigned with different codes or same code assigned with different name, are considered as errors.


Code Name

1 xyz

2 mns

3 xyz

2 pqr

4 abc

5 uio


In the above data, row 1 and row 3 should be error , same for row and row4, row 5 and row 6 are ok


Looking for a formula based approach.


Regards,

Kaushik
 
Array formula:

=IF(AND(IF($B$1:$B$6=B1,$A$1:$A$6,A1)=A1,IF($A$1:$A$6=A1,$B$1:$B$6,B1)=B1),"good","error")


Confirm using Ctrl+Shift+Enter, not just Enter.
 
Hi Kaushik ,


Debraj Roy has posted a solution to a similar problem , posted here :


http://chandoo.org/forums/topic/how-to-identify-different-records-from-2-columns


Narayan
 
Hi Luke,


It is giving me “good” for “1 and xyz” and “3 and xyz” combination. Where as it is supposed to return me error in these cases as different codes can not be assigned for same person and vise versa.


Can u plz check that and modify the formula.


Kaushik
 
Back
Top