Spreadsheet: 51833d1251439279-formula-to-match-between-two-columns-rewards
Sheet: Sheet1

CLIENTTITLE | CLIENT INITIALS | CLIENT SURNAME | CAPTURE DATE | USER ID | Match this column with column E
MR | J L | REYNEKE | 2009-07-01 13:30:03 | EXPN130 | EXSS139
MEV | BA | CARSTENS | 2009-07-01 15:11:36 | ABCW433 | EXKM193
MISS | NE | [NAME] | 2009-07-01 10:01:55 | ABMD419 | ABLP420
Mnr | GW | Laubscher | 2009-07-01 10:24:10 | ABMH452 | ABBT137
Mr | B | Watkins | 2009-07-01 10:26:46 | ABMH452 | EXMT148
MR | BWF | FORGUS | 2009-07-01 11:56:22 | ABCW433 | ABNMADZ
Ms | RW | [NAME] | 2009-07-02 08:46:05 | ABNMADZ | ABRS621
MR | HJ | PIETERSE | 2009-07-02 14:17:32 | EXPM203 | ABDV180
[NAME] | AA | Davids | 2009-07-02 10:53:41 | ABMH452 | ABSD305
MR | H | FRANTZ | 2009-07-03 09:10:33 | ABMMBAO | ABTR217
Mr | MM | [NAME] | 2009-07-03 10:09:46 | ABMH452 | ABMMBAO
MR | D | RATSAKA | 2009-07-03 11:22:38 | ABTR217 | ABKMA78
MISS | NN | SBUKWANA | 2009-07-03 12:35:00 | ABTR217 | EXGM103
Ms | T | Govender | 2009-07-03 14:42:48 | ABMH452 | EXJT108
ms | LYNETTE | STRYDOM | 2009-07-03 11:34:11 | EXNM105 | [NAME]
MR | EZEKIEL | MKONDWANE | 2009-07-06 11:23:21 | EXML129 | EXLL119
MR | NJ | RATSHWENE | 2009-07-06 11:24:58 | ABLV240 | EXMK126
MR | SM | NGCOBO | 2009-07-06 12:48:23 | EXMT148 | EXCM134
MR | AJ | VAN ZYL | 2009-07-06 12:57:20 | ABLV240 | EXZR100
MNR | JVDS | EKMAN | 2009-07-06 13:01:48 | ABLV240 | ABRM956
MISS | LG | KGWATLA | 2009-07-06 13:02:50 | ABLV240 | EXNK128
MR | PF | NHLAPO | 2009-07-06 13:03:41 | ABLV240 | EXBM282
MNR | FJ | SMIT | 2009-07-06 13:04:41 | ABLV240 | EXSK133
MR | SM | NDLALA | 2009-07-06 13:05:37 | ABLV240 | EXML129
MR | R | VAN DER MERWE | 2009-07-06 13:06:25 | ABLV240 | ABMD419
Mr | MI | SHEIK | 2009-07-06 15:01:28 | ABMH452 | ABCW433
MS | NP | NYATHELA | 2009-07-06 15:35:04 | EXPM203 | ABPN476
MR | MP | PHASHA | 2009-07-06 15:36:33 | EXPM203 | ABFM329
MRS | MS | ZIMU | 2009-07-06 17:14:57 | ABLV240 | ABMN629
[NAME] | C | Buys | 2009-07-06 17:39:36 | ABMH452 | EXNM105
MRS | LM | THOMAS | 2009-07-06 17:56:41 | EXMT148 | ABFH909
MR | IB | PHAGE | 2009-07-06 12:45:24 | ABLV240 | ABMMBKY
MR | RN | MOODLEY | 2009-07-06 18:15:11 | ABLV240 | EXTK127
MR | JP | [NAME] | 2009-07-06 12:51:46 | ABLV240 | ABPMA7M
MR | W | PRINSLOO | 2009-07-06 12:52:43 | ABLV240 | EXAT130
MNR | W | VAN WYK | 2009-07-06 12:53:33 | ABLV240 | EXNS241
MR | PE | NDLOVU | 2009-07-06 12:54:22 | ABLV240 | ABNMAD3
MR | TL | KHAILE | 2009-07-06 12:55:24 | ABLV240 | ABCMA2K
MISS | M | ANNANDALE | 2009-07-06 12:56:20 | ABLV240 | ABSW334
MRS | R | NAICKER | 2009-07-06 13:14:26 | ABLV240 | EXVL104
MR | [NAME] | DLOMO | 2009-07-06 14:20:21 | ABFM329 | EXBR103
MR | F | SMALL | 2009-07-06 15:06:43 | ABLV240 | EXRS129
MISS | MV | TSOTETSI | 2009-07-06 15:38:30 | ABLV240 | EXRK111
MISS | MV | TSOTETSI | 2009-07-06 15:52:51 | ABLV240 | ABMH452
MISS | XT | BALENI | 2009-07-06 18:55:29 | ABLV240
Mr | KD | [NAME] | 2009-07-06 18:08:42 | ABMH452
MRS | TL | KNOETZE | 2009-07-07 08:53:46 | [NAME]
MM | MRS | [NAME] | 2009-07-07 09:23:32 | EXPM203
MEV | D | VENTER | 2009-07-07 09:36:12 | ABLV240
Mrs | DJ | Wilson | 2009-07-07 15:23:14 | ABNMADZ
MRS | MM | MAHLANGU | 2009-07-07 16:57:42 | ABLV240
MR | R | TURNER | 2009-07-07 16:59:18 | ABLV240
MISS | JP | VAN LOGGERENBERG | 2009-07-07 17:00:15 | ABLV240
MRS | JM | ERASMUS | 2009-07-07 17:36:04 | ABLV240
MR | JAVZ | BLAAUW | 2009-07-07 17:37:17 | ABLV240
MR | E | SIMELANE | 2009-07-07 17:41:00 | ABLV240
MR | DK | HADEBE | 2009-07-07 17:44:38 | ABLV240
MR | MP | [NAME] | 2009-07-07 17:46:08 | ABLV240
MISS | BN | MNISI | 2009-07-07 17:01:25 | ABLV240
MISS | T | VOSLOO | 2009-07-07 17:02:18 | ABLV240
MR | SR | PHERA | 2009-07-07 17:03:13 | ABLV240
MR | LD | VAN DER WESTHUIZEN | 2009-07-07 17:04:03 | ABLV240
MR | N | [NAME] | 2009-07-07 17:04:53 | ABLV240
MR | HADP | VLOTMAN | 2009-07-07 17:05:57 | ABLV240
MISS | AM | MOLOI | 2009-07-07 17:07:40 | ABLV240
MRS | S | ALLEN | 2009-07-07 17:23:43 | ABLV240
MR | ON | ABDUL | 2009-07-07 17:24:37 | ABLV240
MR | N | ATHMARAM | 2009-07-07 17:26:20 | ABLV240
MRS | G | PILLAY | 2009-07-07 17:27:17 | ABLV240
MISS | SF | GORDON | 2009-07-07 15:25:41 | ABTR217
MR | MG | BARNES | 2009-07-07 17:28:04 | ABLV240
MRS | B | PETERSEN | 2009-07-07 17:32:51 | ABLV240
MRS | ME | MABASA | 2009-07-07 17:33:40 | ABLV240
MRS | CR | GALANT | 2009-07-07 17:35:08 | ABLV240
MRS | SF | [NAME] | 2009-07-07 17:38:19 | ABLV240
MRS | MMS | PHOTOLO | 2009-07-07 17:42:09 | ABLV240
MR | S | TSOTETSI | 2009-07-08 08:57:33 | EXSK133
MISS | S | NKOSI | 2009-07-08 10:35:18 | EXPM203
ms | cw | moig | 2009-07-08 11:28:21 | EXRM175
MR | GL | MALULEKA | 2009-07-08 11:45:39 | ABLV240
MRS | VF | AFRICA | 2009-07-08 12:58:17 | [NAME]
Ms | MC | Motiram | 2009-07-08 13:54:57 | ABMH452
Mr | D | [NAME] | 2009-07-08 14:28:20 | ABMH452
MRS | L | COETZEE | 2009-07-08 15:23:13 | EXCM146
MR | JM | [NAME] | 2009-07-08 09:01:32 | EXSK133
MISS | M | BEKKER | 2009-07-08 09:11:30 | EXPM203
MR | G | MOODLEY | 2009-07-08 11:01:36 | EXSK133
MISS | L | [NAME] | 2009-07-08 15:47:15 | [NAME]
Ms | CK | Luyt | 2009-07-08 09:35:07 | ABMH452
MISS | JL | DE WET | 2009-07-09 12:29:11 | ABLV240
MR | J | MOAKA | 2009-07-09 13:39:29 | EXSK133
MRS | E | TIGHE | 2009-07-09 14:27:28 | ABTR217
MR | D | MODIBA | 2009-07-09 14:28:57 | ABTR217
MR | [NAME] | LEKETE | 2009-07-09 17:54:24 | ABBT137
MRS | E | TIGHE | 2009-07-09 13:51:37 | ABTR217
MRS | E | TIGHE | 2009-07-09 14:27:27 | ABTR217
MISS | M | MASHABA | 2009-07-09 10:57:33 | EXPM203
MISS | TP | [NAME] | 2009-07-09 14:02:52 | EX
MR | OS | MODISAOTSILE | 2009-07-10 14:26:31 | ABSD305
MR | B | MASEKO | 2009-07-10 13:33:00 | ABLV240
MISS | NA | MATHIMBA | 2009-07-10 11:05:49 | ABLV240
Mr | MR | Choglay | 2009-07-10 12:07:34 | ABMH452
MISS | MP | MASHIGO | 2009-07-10 12:11:00 | ABLV240
MISS | MJ | [NAME] | 2009-07-10 12:59:33 | ABLV240
MR | NN | MUTHIVHI | 2009-07-10 17:13:21 | ABLV240
MR | K | MEWALALL | 2009-07-10 16:09:15 | ABLV240
MR | ZJ | MASILELA | 2009-07-13 08:59:43 | ABLV240
MRS | NC | ABRAHAM | 2009-07-13 09:54:17 | ABBT137
MRS | SM | GWAMBE | 2009-07-13 10:24:24 | ABLV240
MISS | LO | STEVENSON | 2009-07-13 11:30:13 | ABLV240
MR | JE | KOK | 2009-07-13 12:12:03 | ABLV240
MR | O | ARENDSE | 2009-07-13 13:05:18 | EXPM203
MR | M S | MALEPE | 2009-07-13 13:58:41 | ABMMBKY
Mr | EJG | BOTHA | 2009-07-13 10:13:41 | ABNMADZ
MR | CC | WOODMAN | 2009-07-13 13:04:14 | EXRS129
MISS | JA | [NAME] | 2009-07-13 14:56:08 | ABLV240
MR | VE | MOHLALA | 2009-07-13 10:56:06 | ABLV240
Miss | R | WOLMAN | 2009-07-13 13:54:10 | ABNMADZ
MR | JM | TSUELA | 2009-07-13 14:24:56 | ABLV240
Mr | MJ | MTHIMKULU | 2009-07-14 09:35:00 | ABLV240
MISS | M | MOTSWENE | 2009-07-14 11:01:36 | ABBT137
MISS | KA | PACKHAM | 2009-07-14 14:19:50 | ABBT137
Mrs | MP | Nzuza | 2009-07-14 15:02:53 | ABMH452
MEV | CP | BOTHA | 2009-07-14 16:20:48 | ABLV240
MISS | KM | Mogole | 2009-07-14 09:37:23 | ABBT137
Mr | J | Becker | 2009-07-14 15:40:29 | ABNMADZ
MRS | NG | MNYAZANA | 2009-07-14 12:47:46 | ABLV240
Mr | JA | Bothma | 2009-07-14 15:24:44 | ABMH452
Mrs | NV | Bolosha | 2009-07-14 11:25:05 | ABMH452
MRS | WD | KORTZE | 2009-07-14 16:59:58 | ABMMBAO
Mr | KI | Bedawala | 2009-07-14 09:30:10 | ABMH452
MR | MS | BENJAMIN | 2009-07-14 09:40:17 | ABCW433
MR | A | Johnstone | 2009-07-14 09:53:46 | ABNMADZ
MR | TE | MALIBE | 2009-07-14 15:51:44 | ABBT137
MR | JO | VENTER | 2009-07-14 09:56:27 | ABLV240
mr | M | 8510185070083 | 2009-07-15 07:43:54 | ABMMBKY
Miss | CA | BYRNE | 2009-07-15 08:58:30 | ABNMADZ
Mnr | elc | CLOETE | 2009-07-15 09:56:56 | ABBT137
MEJ | L | SCHEEPERS | 2009-07-15 14:18:47 | EXGM103
miss | L | SCHEEPERS | 2009-07-15 14:49:56 | EXGM103
mr | id | VAN STADEN | 2009-07-15 15:13:25 | EXFS123
mrs | mjh | BESTER | 2009-07-15 07:42:30 | ABMMBKY
MR | AW | BOTES | 2009-07-15 07:48:24 | ABMMBKY
MR | PB | MASONDO | 2009-07-15 08:35:42 | ABLV240
MR | G S | NEETHLING | 2009-07-15 07:53:30 | ABMMBKY
MISS | RC | MAMASHIE | 2009-07-15 09:07:42 | ABLV240
MR | JP | BROODRYK | 2009-07-15 10:52:39 | EXSK133
MR | JP | BROODRYK | 2009-07-15 10:52:39 | EXSK133
MRS | EM | BRONKHORST | 2009-07-15 10:31:43 | EXSK133
mrs | S | ASSAM | 2009-07-15 07:50:19 | ABMMBKY
mrs | TSHEGOFATSO PATRICIA | KHOZA | 2009-07-16 12:18:38 | EXRM175
MR | JS | MOTAU | 2009-07-16 12:44:57 | EXLL119
MR | FB | MNCUBE | 2009-07-16 13:36:49 | EXSS139
MR | FB | MNCUBE | 2009-07-16 13:39:30 | EXSS139
MR | FB | MNCUBE | 2009-07-16 13:40:54 | EXSS139
mr | dj | LABASE | 2009-07-17 13:38:24 | EXVL104
miss | nc | Mkhondwane | 2009-07-17 13:39:22 | EXVL104
mr | c | Van der westhuizen | 2009-07-17 13:52:20 | EXVL104
miss | gv | Dibane | 2009-07-17 14:07:26 | EXVL104
miss | mg | Ishmael | 2009-07-17 14:15:18 | EXVL104
miss | c | Cooper | 2009-07-17 13:44:29 | EXVL104
miss | f | Vally | 2009-07-17 14:19:00 | EXVL104
miss | tb | MONNAPULA | 2009-07-17 14:05:41 | EXVL104
miss | se | Arendse | 2009-07-17 14:16:28 | EXVL104
mr | j | Groenewald | 2009-07-17 14:09:50 | EXVL104
Miss | NV | Bolosha | 2009-07-20 09:05:52 | ABMH452
Mnr | JA | Bothma | 2009-07-20 09:41:24 | ABMH452
mr | j | Coetsee | 2009-07-20 09:54:39 | EXVL104
mrs | c | Hobanie | 2009-07-20 09:57:28 | EXVL104
MEV | JJ | WILLEMSE | 2009-07-20 10:16:13 | ABKM717
Mrs | TE | Modikela | 2009-07-20 10:25:30 | ABMH452
Mrs | CJ | Southgate | 2009-07-20 11:05:03 | ABMH452
Miss | NR | Jekemba | 2009-07-20 11:15:11 | ABMH452
Miss | FP | Gama | 2009-07-20 11:18:47 | ABMH452
Mrs | CJ | Southgate | 2009-07-20 11:55:08 | ABMH452
Mrs | ML | Gouws | 2009-07-20 11:59:26 | ABMH452
Mr | W | Hugo | 2009-07-20 12:00:53 | ABMH452
MR | II | SAIDI | 2009-07-20 14:27:19 | EXSK133
Mr | KI | Bedawala | 2009-07-20 08:29:25 | ABMH452
Mrs | MP | NZUZA | 2009-07-20 09:38:41 | ABMH452
Mr | C | [NAME] | 2009-07-20 10:08:31 | ABMH452
Mrs | CA | Brand | 2009-07-20 10:11:17 | ABMH452
Mrs | CF | Fourie | 2009-07-20 11:52:19 | ABMH452
Miss | NM | Sibuqo | 2009-07-20 08:54:37 | ABMH452
dr | j | Devenish | 2009-07-20 09:56:04 | EXVL104
Mrs | CF | Fourie | 2009-07-20 11:03:35 | ABMH452
[NAME] | NS | Flippus | 2009-07-20 11:57:20 | ABMH452
mr | r | Fourie | 2009-07-20 12:05:08 | EXVL104
[NAME] | JW | Pieters | 2009-07-20 09:47:50 | ABMH452
Mr | KJ | Radebe | 2009-07-20 10:27:22 | ABMH452
MR | GC | DE-SOUZA ALLEGRIA | 2009-07-21 11:43:14 | EXPM203
MR | D H | NGOBENI | 2009-07-21 14:31:14 | ABMMBKY
Miss | AMIM | Smale | 2009-07-21 08:21:50 | ABMH452
miss | B | SITHOLE | 2009-07-21 11:53:59 | ABMMBKY
mr | te | PHOLO | 2009-07-22 10:00:41 | EXMT148
MRS | M L | MOKWANA | 2009-07-22 11:04:26 | ABMMBKY
MR | AT | MOTLOUNG | 2009-07-22 11:11:50 | EXPM203
MR | W | GQOZO | 2009-07-22 12:05:36 | EXPM203
Mr | LP | MANYANA | 2009-07-23 09:40:46 | ABMH452
Mrs | D | [NAME] | 2009-07-23 15:11:58 | ABMH452
Mr | SO | Matabane | 2009-07-23 10:22:18 | ABMH452
MR | JE | MACAMO | 2009-07-23 10:11:27 | EXPM
MR | CM | KYALUSANZA | 2009-07-24 08:48:32 | ABBT137
MISS | TP | [NAME] | 2009-07-24 11:18:45 | EXPM203
MR | TC | LEDWABA | 2009-07-24 08:58:09 | ABBT137
MISS | O | MOREOSELE | 2009-07-24 08:31:25 | ABBT137
Miss | K | Kuwana | 2009-07-27 14:54:31 | ABMH452
MEV | EJ | THIART | 2009-07-27 18:49:46 | EXMT148
MEV | EJ | THIART | 2009-07-27 18:57:48 | EXMT148
MEV | ELMARIE | MAY | 2009-07-28 12:12:42 | EXSS139
MRS | RT | MATSOSO | 2009-07-28 12:31:21 | EXMT148
Mrs | HM | Van Jaarsveld | 2009-07-28 14:16:05 | ABMH452
Miss | CN | Dlamini | 2009-07-28 14:40:21 | ABMH452
Mrs | XN | [NAME] | 2009-07-28 18:01:18 | ABMH452
Mr | N | Rudloff | 2009-07-29 10:50:48 | ABMH452
Mr | A | Ramokoka | 2009-07-29 12:19:53 | ABMH452
MR | J | LEWIS | 2009-07-29 11:04:06 | ABMMBAO
Mr | MT | Divhula | 2009-07-30 18:13:23 | ABMH452
Mrs | M | Kotze | 2009-07-30 11:08:19 | ABMH452
MISS | MS | RAMOADI | 2009-07-30 11:55:02 | ABLP420
Mrs | D | MANUS | 2009-07-31 18:04:18 | ABMH452