I'm having trouble getting my head around this one....
Col A is the number, Col B is the Code, Col 3 is a flag.
What I want to do is if the code = SLMON MEDIA or SLMONSTER is in Col B look at the number next to it in Col A and tell me if that number appears in the list.
A clearer example is 293957 has SLMON MEDIA and SLREV against it, becasue SLMON MEDIA is there I don't want to see it. If if just had SLREV I do want to see it.
Thanks in advance
Matt
293950__SLTRAD PROD 1
293952__SLTRAD PROD 1
293955__SLTRAD PROD 1
293955__SLTRAD PROD 1
293956__SLMON MEDIA 2
293957__SLMON MEDIA 2
293957__SLREV 1
293957__SLTRAD PROD 1
Col A is the number, Col B is the Code, Col 3 is a flag.
What I want to do is if the code = SLMON MEDIA or SLMONSTER is in Col B look at the number next to it in Col A and tell me if that number appears in the list.
A clearer example is 293957 has SLMON MEDIA and SLREV against it, becasue SLMON MEDIA is there I don't want to see it. If if just had SLREV I do want to see it.
Thanks in advance
Matt
293950__SLTRAD PROD 1
293952__SLTRAD PROD 1
293955__SLTRAD PROD 1
293955__SLTRAD PROD 1
293956__SLMON MEDIA 2
293957__SLMON MEDIA 2
293957__SLREV 1
293957__SLTRAD PROD 1