coliervile
Well-known Member
- Joined
- May 19, 2006
- Messages
- 724
Goooooood morning to everyone-
I have a list of 18 employee names and they are paired together as work teams in columns "X" and "Y" the range is X1:Y18. I would like a macro that would check for dupes of pairings. Here is what I'm looking; in the list below the employees are paired off. I want to check to see if the employees work more than once together. On the sixth line Mary and Robin work together and they also work together on the eighteenth line too. This occurrence also happens with Mike and Lisa. How is the best way to check this or show the result of these occurrences.
Tom---Duane
Mike---Lisa
Steve---Katie
Chris---William
Neal ---Chris
Mary---Robin
Elizabeth---Don
Ann---Elizabeth
Tim---Steve
William---Tom
Terry---Ann
Rich---Gale
Gale---Neal
Don---Rich
Lisa---Mike
Duane---Tim
Katie---Terry
Robin---Mary
Best regards,
Charllie
I have a list of 18 employee names and they are paired together as work teams in columns "X" and "Y" the range is X1:Y18. I would like a macro that would check for dupes of pairings. Here is what I'm looking; in the list below the employees are paired off. I want to check to see if the employees work more than once together. On the sixth line Mary and Robin work together and they also work together on the eighteenth line too. This occurrence also happens with Mike and Lisa. How is the best way to check this or show the result of these occurrences.
Tom---Duane
Mike---Lisa
Steve---Katie
Chris---William
Neal ---Chris
Mary---Robin
Elizabeth---Don
Ann---Elizabeth
Tim---Steve
William---Tom
Terry---Ann
Rich---Gale
Gale---Neal
Don---Rich
Lisa---Mike
Duane---Tim
Katie---Terry
Robin---Mary
Best regards,
Charllie