MS Excel Questions - Excel 2010

Kniteman77

Platinum Member
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
 

PowerEngineer

Diamond Member
Oct 22, 2001
3,598
774
136
There's probably several ways to do this, but here's how I'd do it.

Set up a new column 'E' where each cell has the formula combining the first and last names in columns A and B. For cell E1:
=A1&"$$"&B1
(copied down the column)
Similarly in new column 'F', cell F1:
=C1&"$$"&D1
(copied down the column)
This gives you two columns that each have the combined first and last names.

Now start a new column 'G', where the formula in cell G1:
=IF(ISERROR(MATCH(E1,F:F,0)),"UNMATCHED","OK")
(copied down the column)
The MATCH function fails in the name (AB) does not appear in the other list of names (CD).
 
sale-70-410-exam    | Exam-200-125-pdf    | we-sale-70-410-exam    | hot-sale-70-410-exam    | Latest-exam-700-603-Dumps    | Dumps-98-363-exams-date    | Certs-200-125-date    | Dumps-300-075-exams-date    | hot-sale-book-C8010-726-book    | Hot-Sale-200-310-Exam    | Exam-Description-200-310-dumps?    | hot-sale-book-200-125-book    | Latest-Updated-300-209-Exam    | Dumps-210-260-exams-date    | Download-200-125-Exam-PDF    | Exam-Description-300-101-dumps    | Certs-300-101-date    | Hot-Sale-300-075-Exam    | Latest-exam-200-125-Dumps    | Exam-Description-200-125-dumps    | Latest-Updated-300-075-Exam    | hot-sale-book-210-260-book    | Dumps-200-901-exams-date    | Certs-200-901-date    | Latest-exam-1Z0-062-Dumps    | Hot-Sale-1Z0-062-Exam    | Certs-CSSLP-date    | 100%-Pass-70-383-Exams    | Latest-JN0-360-real-exam-questions    | 100%-Pass-4A0-100-Real-Exam-Questions    | Dumps-300-135-exams-date    | Passed-200-105-Tech-Exams    | Latest-Updated-200-310-Exam    | Download-300-070-Exam-PDF    | Hot-Sale-JN0-360-Exam    | 100%-Pass-JN0-360-Exams    | 100%-Pass-JN0-360-Real-Exam-Questions    | Dumps-JN0-360-exams-date    | Exam-Description-1Z0-876-dumps    | Latest-exam-1Z0-876-Dumps    | Dumps-HPE0-Y53-exams-date    | 2017-Latest-HPE0-Y53-Exam    | 100%-Pass-HPE0-Y53-Real-Exam-Questions    | Pass-4A0-100-Exam    | Latest-4A0-100-Questions    | Dumps-98-365-exams-date    | 2017-Latest-98-365-Exam    | 100%-Pass-VCS-254-Exams    | 2017-Latest-VCS-273-Exam    | Dumps-200-355-exams-date    | 2017-Latest-300-320-Exam    | Pass-300-101-Exam    | 100%-Pass-300-115-Exams    |
http://www.portvapes.co.uk/    | http://www.portvapes.co.uk/    |