Index Match of partial data then date drive results

lndspdr

New Member
Joined
Jan 14, 2019
Messages
2
Hello
Thank you for taking the time to check out my question.
I searched the forum for an answer and I have found things that are in the same area, but not quite what I am looking to do.
I have two sample sheets: source and location

source
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 121px"><col width="177"><col width="171"><col width="100"><col width="100"><col width="100"><col width="198"><col width="178"><col width="100"><col width="100"></colgroup><tbody>[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]Worker[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]Work Email[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]Current Location[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]Current City[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]Worker Type[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]Effective Date[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]Old Location[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]New Location[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]Old State[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]New State[/TD]
[/TR]
[TR]
[TD]Genevieve Jimenez[/TD]
[TD]g.j@co.com[/TD]
[TD]40123 New Street[/TD]
[TD]Los Angeles[/TD]
[TD]Contingent Worker[/TD]
[TD="align: right"]2/27/17[/TD]
[TD]2101 Old Street[/TD]
[TD]40123 New Street[/TD]
[TD]California[/TD]
[TD]California[/TD]
[/TR]
[TR]
[TD]Pam Banks[/TD]
[TD]p.b@co.com[/TD]
[TD]41456 Update Avenue[/TD]
[TD]Los Angeles[/TD]
[TD]Employee[/TD]
[TD="align: right"]12/28/17[/TD]
[TD]2202 Last Drive[/TD]
[TD]41456 Update Avenue[/TD]
[TD]California[/TD]
[TD]California[/TD]
[/TR]
[TR]
[TD]Tasha Bishop[/TD]
[TD]t.b@co.com[/TD]
[TD]42789 Newish Circle[/TD]
[TD]Seattle[/TD]
[TD]Employee[/TD]
[TD="align: right"]8/17/18[/TD]
[TD]2303 Ancient Avenue[/TD]
[TD]42789 Newish Circle[/TD]
[TD]Washington[/TD]
[TD]Washington[/TD]
[/TR]
[TR]
[TD]David Bishop[/TD]
[TD]d.b@co.com[/TD]
[TD]431011 Newton Lane[/TD]
[TD]New York[/TD]
[TD]Employee[/TD]
[TD="align: right"]1/22/18[/TD]
[TD]2404 Oldton Circle[/TD]
[TD]431011 Newton Lane[/TD]
[TD]New York[/TD]
[TD]New York[/TD]
[/TR]
[TR]
[TD]Monica Elliott[/TD]
[TD]m.e@co.com[/TD]
[TD]441213 Latest Avenue[/TD]
[TD]Austin[/TD]
[TD]Employee[/TD]
[TD="align: right"]12/28/17[/TD]
[TD]2505 Previous Lane[/TD]
[TD]441213 Latest Avenue[/TD]
[TD]Texas[/TD]
[TD]California[/TD]
[/TR]
[TR]
[TD]David Jefferson[/TD]
[TD]d.j@co.com[/TD]
[TD]451415 Brand New Drive[/TD]
[TD]Austin[/TD]
[TD]Employee[/TD]
[TD="align: right"]7/17/17[/TD]
[TD]2606 Old School Street[/TD]
[TD]451415 Brand New Drive[/TD]
[TD]Texas[/TD]
[TD]California[/TD]
[/TR]
[TR]
[TD]Lori Mcbride[/TD]
[TD]l.m@co.com[/TD]
[TD]461617 New School Avenue[/TD]
[TD]Los Angeles[/TD]
[TD]Employee[/TD]
[TD="align: right"]7/31/17[/TD]
[TD]2707 Historic Pass[/TD]
[TD]461617 New School Avenue[/TD]
[TD]California[/TD]
[TD]California[/TD]
[/TR]
[TR]
[TD]Carolyn Rhodes[/TD]
[TD]c.r@co.com[/TD]
[TD]471819 Current Lane[/TD]
[TD]Austin[/TD]
[TD]Employee[/TD]
[TD="align: right"]3/19/18[/TD]
[TD]2808 Outdate Circle[/TD]
[TD]471819 Current Lane[/TD]
[TD]Texas[/TD]
[TD]California[/TD]
[/TR]
[TR]
[TD]Ted Wood[/TD]
[TD]t.w@co.com[/TD]
[TD]482021 Now Drive[/TD]
[TD]Los Angeles[/TD]
[TD]Employee[/TD]
[TD="align: right"]4/1/17[/TD]
[TD]2909 Last Avenue[/TD]
[TD]482021 Now Drive[/TD]
[TD]California[/TD]
[TD]California[/TD]
[/TR]
[TR]
[TD]Kenneth Franklin[/TD]
[TD]k.f@co.com[/TD]
[TD]492223 Recent Circle[/TD]
[TD]New York[/TD]
[TD]Contingent Worker[/TD]
[TD="align: right"]7/31/17[/TD]
[TD]3001 History Lane[/TD]
[TD]492223 Recent Circle[/TD]
[TD]New York[/TD]
[TD]New York[/TD]
[/TR]
</tbody>[/TABLE]


location
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 100px"><col width="100"><col width="143"><col width="100"><col width="179"></colgroup><tbody>[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]Issue[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]Project[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]Reporter[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]Created Date[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]Updated Location[/TD]
[/TR]
[TR]
[TD]task-1011[/TD]
[TD]IT[/TD]
[TD]Genevieve Jimenez[/TD]
[TD="align: right"]1/29/18[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]task-1213[/TD]
[TD]ENG[/TD]
[TD]Pam Banks[/TD]
[TD="align: right"]2/6/18[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]task-1415[/TD]
[TD]IT[/TD]
[TD]Tasha Bishop[/TD]
[TD="align: right"]3/13/17[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]task-1617[/TD]
[TD]ENG[/TD]
[TD]David Bishop[/TD]
[TD="align: right"]4/10/17[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]task-1819[/TD]
[TD]IT[/TD]
[TD]Monica Elliott[/TD]
[TD="align: right"]4/19/17[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]task-2021[/TD]
[TD]ENG[/TD]
[TD]David Jefferson[/TD]
[TD="align: right"]4/20/17[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]task-2223[/TD]
[TD]IT[/TD]
[TD]Lori Mcbride[/TD]
[TD="align: right"]1/7/19[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]task-2425[/TD]
[TD]ENG[/TD]
[TD]Carolyn Rhodes[/TD]
[TD="align: right"]6/20/17[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]task-2627[/TD]
[TD]IT[/TD]
[TD]Ted Wood[/TD]
[TD="align: right"]1/2/19[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]task-2829[/TD]
[TD]ENG[/TD]
[TD]Kenneth Franklin[/TD]
[TD="align: right"]10/10/17[/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]


On the location sheet in the "Updated Location" column I am trying to determine the location of an individual based on the closest but not over "Effective Date" on the source sheet.
It feels like two functions and I have been able to get close, but not quite to what feels like the right answer.

Using
Code:
[COLOR=#000000][FONT=Inconsolata]=[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]INDEX[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]([/FONT][/COLOR][COLOR=#F7981D][FONT=Inconsolata]source!C:C[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata],[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]MATCH[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]([/FONT][/COLOR][COLOR=green][FONT=Inconsolata]"*"[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]&[/FONT][/COLOR][COLOR=#7E3794][FONT=Inconsolata]C3[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]&[/FONT][/COLOR][COLOR=green][FONT=Inconsolata]"*"[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata],[/FONT][/COLOR][COLOR=#11A9CC][FONT=Inconsolata]source!$A:$A[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata],[/FONT][/COLOR][COLOR=#1155CC][FONT=Inconsolata]0[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata])[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata])[/FONT][/COLOR]
I am able to find partial matches based on the names in source!C:C.
That returns the first match.
I am hoping to get a reduced scope of partial matches that would then compare dates and find the closest but not over match.
Something along the line of
Code:
E2>=source!F2,source!G2,source!H2

I feel I may have to do another scope reduction to closer to a match before I compare dates.
Just tossing some pseudo code to better explain myself:

Select source:"New Location" where source:worker is like "Bishop" and where source worker is like "Tasha" and where source:"Effective Date" is equal to or less than Location:"Created Date" Else select source:"Old Location"

In the end I would like the column location:"Updated Location" to be populated with the date driven, name matching result.

Any thoughts on this or different approaches would be welcomed.
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
You talk about "partial matches" and use phrases like "where source:worker is like "Bishop" and where source worker is like "Tasha"" but in fact you have no duplicate names and each is a perfect match in your "source" and "location" tabs. If this is not the case then please give examples where perfect matches might not appear. Excel does not have a "Fuzzy Match" option but there is an Add-in you may try.

I put your "location" into Excel:
[TABLE="width: 1092"]
<colgroup><col><col><col><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Worker
[/TD]
[TD]Work Email[/TD]
[TD]Current Location[/TD]
[TD]Current City[/TD]
[TD]Worker Type[/TD]
[TD]Effective Date[/TD]
[TD]Old Location[/TD]
[TD]New Location[/TD]
[TD]Old State[/TD]
[TD]New State[/TD]
[/TR]
[TR]
[TD]Genevieve Jimenez[/TD]
[TD]g.j@co.com[/TD]
[TD]40123 New Street[/TD]
[TD]Los Angeles[/TD]
[TD]Contingent Worker
[/TD]
[TD]2/27/2017[/TD]
[TD]2101 Old Street
[/TD]
[TD]40123 New Street[/TD]
[TD]California[/TD]
[TD]California[/TD]
[/TR]
[TR]
[TD]Pam Banks[/TD]
[TD]p.b@co.com[/TD]
[TD]41456 Update Avenue[/TD]
[TD]Los Angeles[/TD]
[TD]Employee[/TD]
[TD]12/28/2017[/TD]
[TD]2202 Last Drive[/TD]
[TD]41456 Update Avenue[/TD]
[TD]California[/TD]
[TD]California[/TD]
[/TR]
[TR]
[TD]Tasha Bishop[/TD]
[TD]t.b@co.com[/TD]
[TD]42789 Newish Circle[/TD]
[TD]Seattle[/TD]
[TD]Employee[/TD]
[TD]8/17/2018[/TD]
[TD]2303 Ancient Avenue[/TD]
[TD]42789 Newish Circle[/TD]
[TD]Washington[/TD]
[TD]Washington[/TD]
[/TR]
[TR]
[TD]David Bishop[/TD]
[TD]d.b@co.com[/TD]
[TD]431011 Newton Lane[/TD]
[TD]New York[/TD]
[TD]Employee[/TD]
[TD]1/22/2018[/TD]
[TD]2404 Oldton Circle[/TD]
[TD]431011 Newton Lane[/TD]
[TD]New York[/TD]
[TD]New York[/TD]
[/TR]
[TR]
[TD]Monica Elliott[/TD]
[TD]m.e@co.com[/TD]
[TD]441213 Latest Avenue[/TD]
[TD]Austin[/TD]
[TD]Employee[/TD]
[TD]12/28/2017[/TD]
[TD]2505 Previous Lane[/TD]
[TD]441213 Latest Avenue[/TD]
[TD]Texas[/TD]
[TD]California[/TD]
[/TR]
[TR]
[TD]David Jefferson[/TD]
[TD]d.j@co.com[/TD]
[TD]451415 Brand New Drive[/TD]
[TD]Austin[/TD]
[TD]Employee[/TD]
[TD]7/17/2017[/TD]
[TD]2606 Old School Street[/TD]
[TD]451415 Brand New Drive[/TD]
[TD]Texas[/TD]
[TD]California[/TD]
[/TR]
[TR]
[TD]Lori Mcbride[/TD]
[TD]l.m@co.com[/TD]
[TD]461617 New School Avenue[/TD]
[TD]Los Angeles[/TD]
[TD]Employee[/TD]
[TD]7/31/2017[/TD]
[TD]2707 Historic Pass[/TD]
[TD]461617 New School Avenue[/TD]
[TD]California[/TD]
[TD]California[/TD]
[/TR]
[TR]
[TD]Carolyn Rhodes[/TD]
[TD]c.r@co.com[/TD]
[TD]471819 Current Lane[/TD]
[TD]Austin[/TD]
[TD]Employee[/TD]
[TD]3/19/2018[/TD]
[TD]2808 Outdate Circle[/TD]
[TD]471819 Current Lane[/TD]
[TD]Texas[/TD]
[TD]California[/TD]
[/TR]
[TR]
[TD]Ted Wood[/TD]
[TD]t.w@co.com[/TD]
[TD]482021 Now Drive[/TD]
[TD]Los Angeles[/TD]
[TD]Employee[/TD]
[TD]4/1/2017[/TD]
[TD]2909 Last Avenue[/TD]
[TD]482021 Now Drive[/TD]
[TD]California[/TD]
[TD]California[/TD]
[/TR]
[TR]
[TD]Kenneth Franklin[/TD]
[TD]k.f@co.com[/TD]
[TD]492223 Recent Circle[/TD]
[TD]New York[/TD]
[TD]Contingent Worker[/TD]
[TD]7/31/2017[/TD]
[TD]3001 History Lane[/TD]
[TD]492223 Recent Circle[/TD]
[TD]New York[/TD]
[TD]New York[/TD]
[/TR]
</tbody>[/TABLE]

...then your "source" into Excel
[TABLE="width: 597"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Issue
[/TD]
[TD]Project[/TD]
[TD]Reporter[/TD]
[TD]Created Date[/TD]
[TD]Updated Location[/TD]
[/TR]
[TR]
[TD]task-1011[/TD]
[TD]IT[/TD]
[TD]Genevieve Jimenez[/TD]
[TD]1/29/2018[/TD]
[TD]40123 New Street
[/TD]
[/TR]
[TR]
[TD]task-1213[/TD]
[TD]ENG[/TD]
[TD]Pam Banks[/TD]
[TD]2/6/2018[/TD]
[TD]41456 Update Avenue[/TD]
[/TR]
[TR]
[TD]task-1415[/TD]
[TD]IT[/TD]
[TD]Tasha Bishop[/TD]
[TD]3/13/2017[/TD]
[TD]2303 Ancient Avenue[/TD]
[/TR]
[TR]
[TD]task-1617[/TD]
[TD]ENG[/TD]
[TD]David Bishop[/TD]
[TD]4/10/2017[/TD]
[TD]2404 Oldton Circle[/TD]
[/TR]
[TR]
[TD]task-1819[/TD]
[TD]IT[/TD]
[TD]Monica Elliott[/TD]
[TD]4/19/2017[/TD]
[TD]2505 Previous Lane[/TD]
[/TR]
[TR]
[TD]task-2021[/TD]
[TD]ENG[/TD]
[TD]David Jefferson[/TD]
[TD]4/20/2017[/TD]
[TD]2606 Old School Street[/TD]
[/TR]
[TR]
[TD]task-2223[/TD]
[TD]IT[/TD]
[TD]Lori Mcbride[/TD]
[TD]1/7/2019[/TD]
[TD]461617 New School Avenue[/TD]
[/TR]
[TR]
[TD]task-2425[/TD]
[TD]ENG[/TD]
[TD]Carolyn Rhodes[/TD]
[TD]6/20/2017[/TD]
[TD]2808 Outdate Circle[/TD]
[/TR]
[TR]
[TD]task-2627[/TD]
[TD]IT[/TD]
[TD]Ted Wood[/TD]
[TD]1/2/2019[/TD]
[TD]482021 Now Drive[/TD]
[/TR]
[TR]
[TD]task-2829[/TD]
[TD]ENG[/TD]
[TD]Kenneth Franklin[/TD]
[TD]10/10/2017[/TD]
[TD]492223 Recent Circle[/TD]
[/TR]
</tbody>[/TABLE]

...so the data for each starts in row 2 (not sure why you were using C3).

The formula I used to retrieve the address was:
=INDEX(Source!G:H,MATCH("*"&C2&"*",Source!$A:$A,0),IF(INDEX(Source!F:F,MATCH("*"&C2&"*",Source!$A:$A,0))-D2<0,2,1))

So the "*"&&"*" wraparounds are superfluous unless you can clarify my question above.

The INDEX function lets you retrieve from a specific row and column so I INDEX both columns G & H (Old Location and New Location).
The first part searches for the row which matches by name: =INDEX(Source!G:H,MATCH("*"&C2&"*",Source!$A:$A,0)
The second part is the column number for the INDEX so I MATCH again for the name but INDEX into the Effective Date. The IF says if that Effective Date I've just retrieved minus D2 (Created Date) is less than zero then I want the 2nd column H, otherwise I want the first column G.

Copy that formula down every row where you've "location" data and it should work.
 
Upvote 0
Thank you Toadstool this definitely gets me closer to what I was thinking.
Your question about partial versus perfect match. I just recreated a small subset of data I am digging through and should have included matching names.
In the thousands of rows we are digging through there are exact matches in the worker column.
There are times when the same worker has moved multiple times and thus has multiple rows.

Something like this would be accurate
[TABLE="class: cms_table, width: 1092"]
<tbody>[TR]
[TD]Worker
[/TD]
[TD]Work Email[/TD]
[TD]Current Location[/TD]
[TD]Current City[/TD]
[TD]Worker Type[/TD]
[TD]Effective Date[/TD]
[TD]Old Location[/TD]
[TD]New Location[/TD]
[TD]Old State[/TD]
[TD]New State[/TD]
[/TR]
[TR]
[TD]Genevieve Jimenez[/TD]
[TD]g.j@co.com[/TD]
[TD]40123 New Street[/TD]
[TD]Los Angeles[/TD]
[TD]Contingent Worker[/TD]
[TD]2/27/2017[/TD]
[TD]2101 Old Street[/TD]
[TD]40123 New Street[/TD]
[TD]California[/TD]
[TD]California[/TD]
[/TR]
[TR]
[TD]Pam Banks[/TD]
[TD]p.b@co.com[/TD]
[TD]41456 Update Avenue[/TD]
[TD]Los Angeles[/TD]
[TD]Employee[/TD]
[TD]12/28/2017[/TD]
[TD]2202 Last Drive[/TD]
[TD]41456 Update Avenue[/TD]
[TD]California[/TD]
[TD]California[/TD]
[/TR]
[TR]
[TD]Tasha Bishop[/TD]
[TD]t.b@co.com[/TD]
[TD]441213 Latest Avenue[/TD]
[TD]Seattle[/TD]
[TD]Employee[/TD]
[TD]8/17/2018[/TD]
[TD]2303 Ancient Avenue[/TD]
[TD]42789 Newish Circle[/TD]
[TD]Washington[/TD]
[TD]Washington[/TD]
[/TR]
[TR]
[TD]Tasha Bishop[/TD]
[TD]t.b@co.com[/TD]
[TD]441213 Latest Avenue[/TD]
[TD]New York[/TD]
[TD]Employee[/TD]
[TD]1/22/2018[/TD]
[TD]2404 Oldton Circle[/TD]
[TD]431011 Newton Lane[/TD]
[TD]New York[/TD]
[TD]New York[/TD]
[/TR]
[TR]
[TD]Tasha Bishop[/TD]
[TD]t.b@co.com[/TD]
[TD]441213 Latest Avenue[/TD]
[TD]Austin[/TD]
[TD]Employee[/TD]
[TD]12/28/2017[/TD]
[TD]2505 Previous Lane[/TD]
[TD]441213 Latest Avenue[/TD]
[TD]Texas[/TD]
[TD]California[/TD]
[/TR]
[TR]
[TD]David Jefferson[/TD]
[TD]d.j@co.com[/TD]
[TD]451415 Brand New Drive[/TD]
[TD]Austin[/TD]
[TD]Employee[/TD]
[TD]7/17/2017[/TD]
[TD]2606 Old School Street[/TD]
[TD]451415 Brand New Drive[/TD]
[TD]Texas[/TD]
[TD]California[/TD]
[/TR]
[TR]
[TD]Lori Mcbride[/TD]
[TD]l.m@co.com[/TD]
[TD]461617 New School Avenue[/TD]
[TD]Los Angeles[/TD]
[TD]Employee[/TD]
[TD]7/31/2017[/TD]
[TD]2707 Historic Pass[/TD]
[TD]461617 New School Avenue[/TD]
[TD]California[/TD]
[TD]California[/TD]
[/TR]
[TR]
[TD]Ted Wood[/TD]
[TD]t.w@co.com[/TD]
[TD]492223 Recent Circle[/TD]
[TD]Austin[/TD]
[TD]Employee[/TD]
[TD]3/19/2018[/TD]
[TD]2808 Outdate Circle[/TD]
[TD]471819 Current Lane[/TD]
[TD]Texas[/TD]
[TD]California[/TD]
[/TR]
[TR]
[TD]Ted Wood[/TD]
[TD]t.w@co.com[/TD]
[TD]492223 Recent Circle[/TD]
[TD]Los Angeles[/TD]
[TD]Employee[/TD]
[TD]4/1/2017[/TD]
[TD]2909 Last Avenue[/TD]
[TD]482021 Now Drive[/TD]
[TD]California[/TD]
[TD]California[/TD]
[/TR]
[TR]
[TD]Ted Wood[/TD]
[TD]t.w@co.com[/TD]
[TD]492223 Recent Circle[/TD]
[TD]New York[/TD]
[TD]Contingent Worker[/TD]
[TD]7/31/2017[/TD]
[TD]3001 History Lane[/TD]
[TD]492223 Recent Circle[/TD]
[TD]New York[/TD]
[TD]New York[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,287
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top