Spreadsheet: 34900d1232335746-comparing-3-or-more-columns-to-find-matches-examples
Sheet: Sheet1

No. | KCU | CAPEM | ACCOUNT OFFICER | PRODUCT | KODE AO | [NAME] BEKERJA |  | No. | KCU | CAPEM | ACCOUNT OFFICER | PRODUCT | KODE AO | [NAME] BEKERJA |  | No. | KCU | CAPEM | ACCOUNT OFFICER | PRODUCT | KODE AO | [NAME] BEKERJA
5 | Batam | KCP [NAME] | [NAME] | UMUM | 0 | 1992-10-06 00:00:00 |  | 6 | Batam | KCP [NAME] | [NAME] | UMUM | 0 | 1992-10-06 00:00:00 |  |  |  |  |  |  |  |  |  | OK
6 | Serang | KCP Karawaci | Suwarto | UMUM | 131 | 26 Desember 2007 |  | 6 | Serang | KCP Karawaci | Suwarto | UMUM | 131 | 26 Desember 2007 |  | 6 | Serang | KCP Karawaci | Suwarto | UMUM | 131 | 26 Desember 2007 |  | OK
5 | Serang | [NAME] | [NAME] | UMUM | 138 | 2006-02-22 00:00:00 |  | 5 | Serang | [NAME] | [NAME] | UMUM | 138 | 2006-02-22 00:00:00 |  | 5 | Serang | [NAME] | [NAME] | UMUM | 138 | 2006-02-22 00:00:00 |  | OK
4 | Serang | [NAME] | Novia Satta | UMUM | 139 | 2006-09-18 00:00:00 |  | 4 | Serang | [NAME] | Novia Satta | UMUM | 139 | 2006-09-18 00:00:00 |  | 4 | Serang | [NAME] | Novia Satta | UMUM | 139 | 2006-09-18 00:00:00 |  | OK
2 | Serang | KCP Cilegon | Hardiyus | UMUM | 140 | 2006-07-24 00:00:00 |  | 2 | Serang | KCP Cilegon | Hardiyus | UMUM | 140 | 2006-07-24 00:00:00 |  | 3 | Serang | [NAME] | [NAME] | UMUM | 141 | 2007-09-19 00:00:00 |  | #N/A
3 | Serang | [NAME] | [NAME] | UMUM | 141 | 2007-09-19 00:00:00 |  | 3 | Serang | [NAME] | [NAME] | UMUM | 141 | 2007-09-19 00:00:00 |  | 7 | Serang | KCP Karawaci | Yugo Tri Aryanto | UMUM | 144 | 2007-03-12 00:00:00 |  | #N/A
1 | Serang | [NAME] | [NAME] | UMUM | 142 | 2007-01-02 00:00:00 |  |  |  |  |  |  |  |  |  | 18 | Surabaya Coklat | KCP Dharmahusada | Welly | SMB | 164 | 2008-02-05 00:00:00 |  | Fail
7 | Serang | KCP Karawaci | Yugo Tri Aryanto | UMUM | 144 | 2007-03-12 00:00:00 |  | 7 | Serang | KCP Karawaci | Yugo Tri Aryanto | UMUM | 144 | 2007-03-12 00:00:00 |  | 13 | Surabaya Coklat | KPR Center | [NAME] | KPR | 167 | 2005-01-18 00:00:00 |  | #N/A
28 | Surabaya Coklat | KCP Dharmahusada | Welly (BARU) | SMB | 164 | 2008-02-05 00:00:00 |  | 27 | Surabaya Coklat | KCP Dharmahusada | Welly | SMB | 164 | 2008-02-05 00:00:00 |  | 14 | Surabaya Coklat | KPR Center | [NAME] | KPR | 168 | 2004-07-06 00:00:00 |  | #N/A
4 | Surabaya Coklat | KPR Center | [NAME] | KPR | 167 | 2005-01-18 00:00:00 |  | 4 | Surabaya Coklat | KPR Center | [NAME] | KPR | 167 | 2005-01-18 00:00:00 |  | 12 | Surabaya Coklat | KPR Center | Rachman Wahyu | KPR | 185 | 2006-06-01 00:00:00 |  | #N/A
5 | Surabaya Coklat | KPR Center | [NAME] | KPR | 168 | 2004-07-06 00:00:00 |  | 5 | Surabaya Coklat | KPR Center | [NAME] | KPR | 168 | 2004-07-06 00:00:00 |  | 11 | Surabaya Coklat | KPR Center | [NAME] | KPR | 186 | 2005-03-21 00:00:00 |  | #N/A
3 | Surabaya Coklat | KPR Center | Rachman Wahyu | KPR | 185 | 2006-06-01 00:00:00 |  | 3 | Surabaya Coklat | KPR Center | Rachman Wahyu | KPR | 185 | 2006-06-01 00:00:00 |  | 3 | Samarinda | [NAME] | Inggrid Gunawan | UMUM | 234 | 2004-11-26 00:00:00 |  | #N/A
2 | Surabaya Coklat | KPR Center | [NAME] (SEBELUMNYA AO SMB) | KPR | 186 | 2005-03-21 00:00:00 |  | 2 | Surabaya Coklat | KPR Center | [NAME] | KPR | 186 | 2005-03-21 00:00:00 |  | 1 | Samarinda | [NAME] | [NAME] | SMB | 235 | 2005-12-26 00:00:00 |  | #N/A
4 | Samarinda | [NAME] | Inggrid Gunawan | UMUM | 234 | 2004-11-26 00:00:00 |  | 4 | Samarinda | [NAME] | Inggrid Gunawan | UMUM | 234 | 2004-11-26 00:00:00 |  | 2 | Samarinda | [NAME] | [NAME] | SMB | 236 | 2007-05-03 00:00:00 |  | #N/A
1 | Samarinda | [NAME] | [NAME] | SMB | 235 | 2005-12-26 00:00:00 |  | 1 | Samarinda | [NAME] | [NAME] | SMB | 235 | 2005-12-26 00:00:00 |  | 19 | Surabaya - Cendana | KCU Cendana | [NAME] | SMB | 251 | 2006-09-25 00:00:00 |  | #N/A
2 | Samarinda | [NAME] | [NAME] | SMB | 236 | 2007-05-03 00:00:00 |  | 2 | Samarinda | [NAME] | [NAME] | SMB | 236 | 2007-05-03 00:00:00 |  | 15 | Surabaya - Cendana | KCU Cendana | Denny Andhika Bhakti | SMB | 253 | 2005-08-01 00:00:00 |  | #N/A
3 | Samarinda | [NAME] | [NAME] (SEBELUMNYA AO KPM) | UMUM | 237 | 2007-04-26 00:00:00 |  | 3 | Samarinda | [NAME] | [NAME] | UMUM | 237 | 2007-04-26 00:00:00 |  | 4 | Surabaya - Cendana | KCU Cendana | [NAME] | SMB | 254 | 2006-10-09 00:00:00 |  | #N/A
16 | Surabaya - Cendana | KCU Cendana | [NAME] | SMB | 251 | 2006-09-25 00:00:00 |  | 15 | Surabaya - Cendana | KCU Cendana | [NAME] | SMB | 251 | 2006-09-25 00:00:00 |  | 16 | Surabaya - Cendana | KCU Cendana | [NAME] | SMB | 255 | 2006-10-09 00:00:00 |  | #N/A