- Mar 15, 2004
- 2,917
- 0
- 76
So I need to do some rather complex sorting/matching in excel, and I'm not really sure where to start. So I thought I'd post this here while I experiment.
I have basically 4 columns of names.
First Last First Last, A B C D
It's known that A is a subset of C and B is a subset of D
I need to make sure that if any pair of A and B is also found paired in C and D, it's flagged as a potential match.
AB and CD must stay paired.
Any advice? Good places to start reading?
Thanks!
Tim
I have basically 4 columns of names.
First Last First Last, A B C D
It's known that A is a subset of C and B is a subset of D
I need to make sure that if any pair of A and B is also found paired in C and D, it's flagged as a potential match.
AB and CD must stay paired.
Any advice? Good places to start reading?
Thanks!
Tim