Hi All, I'm looking to isolate cases where 2 values from column B are present within their own grouping as determined by column A. That sounds wordy but I believe this will clarify:
A B
1 Adam
1 Ben
1 Chris
1 Dave
1 Evan
2 Frank
2 Gary
2 Henry
2 Irene
2 Jon
What I would like to know is within the 1's if Adam and Chris are together (they are, and they shouldn't be) and either highlight their names or put an "x" next to them or something along those lines. Then I want to check if within the 2's if Adam and Henry are together (they are not, and they shouldn't be)... and so on.
Any help would be greatly appreciated.
Thank you!
Bookmarks