Need a VBA script to pull most recent training dates

aba1csims

New Member
Joined
Feb 18, 2022
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Hello! I need a VBA script to find/match an employee with a training course completion date. Here are the circumstances that elevate this past vlookup:
  1. Employee last names - different employees share a last name
  2. Courses are duplicated - 1 single employee has taken a course multiple times (need most recent date)
  3. Course names are not completely standardized, so prefixes and suffixes need to be ignored
  4. Course completion date could be blank - this employee hasn't finished the coursE
If you look at the attachment, the idea is that the Training Database spits out a list of Employees, Course titles, and Completion dates, which the user would paste onto the sheet "Output from Training Database". The VBA script would then add the most recent Completion date to the sheet titled "Course Completion Date".

Dunder Mifflin Training.xlsx
ABCDEFGHIJKL
1NameEmailLeadershipEffective Team CommunicationProject ManagementNegotiationConflict ResolutionTime ManagementEmotional IntelligenceCompliance TrainingDecision MakingStress Management
2Beesly, PamPam.Beesly@dm.com
3Bernard, AndyAndy.Bernard@dm.com
4Bertram, NellieNellie.Bertram@dm.com
5Bratton, CreedCreed.Bratton@dm.com
6California, RobertRobert.California@dm.com
7Filippelli, KarenKaren.Filippelli@dm.com
8Flax, HollyHolly.Flax@dm.com
9Flenderson, TobyToby.Flenderson@dm.com
10Green, ClarkClark.Green@dm.com
11Halpert, JimJim.Halpert@dm.com
12Hannon, ErinErin.Hannon@dm.com
13Howard, RyanRyan.Howard@dm.com
14Hudson, StanleyStanley.Hudson@dm.com
15Kapoor, KellyKelly.Kapoor@dm.com
16Levinson, JanJan.Levinson@dm.com
17Lewis, GabeGabe.Lewis@dm.com
18Lewis, ZacharyZachary.Lewis@dm.com
19Malone, KevinKevin.Malone@dm.com
20Martin, AngelaAngela.Martin@dm.com
21Martin, DavidDavid.Martin@dm.com
22Martinez, CarlosCarlos.Martinez@dm.com
23Martinez, JoseJose.Martinez@dm.com
24Martinez, OscarOscar.Martinez@dm.com
25Miller, PetePete.Miller@dm.com
26Miner, AnthonyAnthony.Miner@dm.com
27Miner, CharlesCharles.Miner@dm.com
28Packer, ToddTodd.Packer@dm.com
29Palmer, MeredithMeredith.Palmer@dm.com
30Philbin, DarrylDarryl.Philbin@dm.com
31Schrute, DwightDwight.Schrute@dm.com
32Schrute, MoseMose.Schrute@dm.com
33Scott, MichaelMichael.Scott@dm.com
34Vance, PhyllisPhyllis.Vance@dm.com
35Vickers, DeangeloDeangelo.Vickers@dm.com
36Wallace, DavidDavid.Wallace@dm.com
Course Completion Date



Dunder Mifflin Training.xlsx
ABCDE
1LastFirstEmailCourseCompletion Date
2BeeslyPamPam.Beesly@dm.comTime Management1/18/2022
3BeeslyPamPam.Beesly@dm.comCompliance Training10/13/2019
4BeeslyPamPam.Beesly@dm.comCompliance Training9/14/2020
5BeeslyPamPam.Beesly@dm.comTeam Project Management5/25/2018
6BeeslyPamPam.Beesly@dm.comConflict Resolution for co-workers9/25/2019
7BeeslyPamPam.Beesly@dm.com**Emotional Intelligence12/4/2021
8BeeslyPamPam.Beesly@dm.comConflict Resolution6/9/2019
9BeeslyPamPam.Beesly@dm.comConflict Resolution12/17/2018
10BeeslyPamPam.Beesly@dm.comNegotiation 1012/5/2018
11BernardAndyAndy.Bernard@dm.comConflict Resolution for co-workers11/12/2017
12BernardAndyAndy.Bernard@dm.comEffective Team Communication - Portal9/7/2021
13BernardAndyAndy.Bernard@dm.comTeam Project Management6/17/2018
14BernardAndyAndy.Bernard@dm.com**Emotional Intelligence4/24/2021
15BernardAndyAndy.Bernard@dm.com**Emotional Intelligence12/1/2021
16BernardAndyAndy.Bernard@dm.comEmotional Intelligence11/14/2021
17BernardAndyAndy.Bernard@dm.comTeam Project Management11/12/2021
18BernardAndyAndy.Bernard@dm.comDecision Making 201910/23/2021
19BertramNellieNellie.Bertram@dm.comNegotiation1/5/2018
20BertramNellieNellie.Bertram@dm.comStress Management in the workplace7/1/2018
21BertramNellieNellie.Bertram@dm.comNegotiation2/17/2018
22BertramNellieNellie.Bertram@dm.comDecision Making10/28/2018
23BertramNellieNellie.Bertram@dm.comEffective Team Communication10/29/2020
24BertramNellieNellie.Bertram@dm.comLeadership 20205/20/2018
25BertramNellieNellie.Bertram@dm.comEmpoloyee Compliance Training7/8/2018
26BertramNellieNellie.Bertram@dm.comLeadership 20209/25/2020
27BrattonCreedCreed.Bratton@dm.comLeadership10/2/2021
28BrattonCreedCreed.Bratton@dm.comCompliance Training2/8/2021
29BrattonCreedCreed.Bratton@dm.comStress Management in the workplace5/13/2021
30BrattonCreedCreed.Bratton@dm.comTime Management11/11/2019
31BrattonCreedCreed.Bratton@dm.com**Emotional Intelligence9/17/2019
32BrattonCreedCreed.Bratton@dm.comConflict Resolution for co-workers2/7/2022
33BrattonCreedCreed.Bratton@dm.comConflict Resolution for co-workers2/25/2019
34BrattonCreedCreed.Bratton@dm.comNegotiation 1017/18/2021
35BrattonCreedCreed.Bratton@dm.comLeadership6/7/2020
36CaliforniaRobertRobert.California@dm.comLeadership 20209/27/2019
37CaliforniaRobertRobert.California@dm.comTime Management10/18/2019
38CaliforniaRobertRobert.California@dm.comProject Management10/4/2019
39CaliforniaRobertRobert.California@dm.comLeadership10/24/2017
40CaliforniaRobertRobert.California@dm.comEffective Team Communication5/10/2020
41CaliforniaRobertRobert.California@dm.comNegotiation 10110/8/2017
42CaliforniaRobertRobert.California@dm.comConflict Resolution for co-workers12/30/2017
43CaliforniaRobertRobert.California@dm.comConflict Resolution2/4/2020
44FilippelliKarenKaren.Filippelli@dm.comLeadership3/11/2021
45FilippelliKarenKaren.Filippelli@dm.com*Time Management2/17/2018
46FilippelliKarenKaren.Filippelli@dm.comDecision Making 2019
47FilippelliKarenKaren.Filippelli@dm.comStress Management in the workplace7/13/2018
48FilippelliKarenKaren.Filippelli@dm.comTime Management12/4/2019
49FilippelliKarenKaren.Filippelli@dm.comConflict Resolution10/20/2018
50FilippelliKarenKaren.Filippelli@dm.comEmotional Intelligence3/29/2018
51FilippelliKarenKaren.Filippelli@dm.comDecision Making6/16/2021
52FlaxHollyHolly.Flax@dm.comEmotional Intelligence1/16/2020
53FlaxHollyHolly.Flax@dm.comTime Management12/23/2019
54FlaxHollyHolly.Flax@dm.com*Time Management5/6/2021
55FlaxHollyHolly.Flax@dm.comEmpoloyee Compliance Training8/31/2019
56FlaxHollyHolly.Flax@dm.comTime Management1/11/2020
57FlaxHollyHolly.Flax@dm.comStress Management10/25/2021
58FlaxHollyHolly.Flax@dm.comDecision Making8/27/2021
59FlaxHollyHolly.Flax@dm.comEffective Team Communication - Portal7/12/2019
60FlendersonTobyToby.Flenderson@dm.comDecision Making12/31/2019
61FlendersonTobyToby.Flenderson@dm.comConflict Resolution for co-workers9/5/2020
62FlendersonTobyToby.Flenderson@dm.comConflict Resolution for co-workers9/8/2019
63FlendersonTobyToby.Flenderson@dm.comStress Management in the workplace6/5/2020
64FlendersonTobyToby.Flenderson@dm.com**Emotional Intelligence3/11/2021
65FlendersonTobyToby.Flenderson@dm.comLeadership3/12/2020
66FlendersonTobyToby.Flenderson@dm.comDecision Making 20194/12/2019
67FlendersonTobyToby.Flenderson@dm.comEmpoloyee Compliance Training5/14/2019
68FlendersonTobyToby.Flenderson@dm.comEffective Team Communication - Portal3/5/2019
69GreenClarkClark.Green@dm.comEffective Team Communication7/9/2019
70GreenClarkClark.Green@dm.comConflict Resolution1/27/2022
71GreenClarkClark.Green@dm.comLeadership7/27/2018
72GreenClarkClark.Green@dm.comEmotional Intelligence7/12/2019
73GreenClarkClark.Green@dm.comStress Management in the workplace5/28/2021
74GreenClarkClark.Green@dm.comLeadership8/19/2021
75GreenClarkClark.Green@dm.comEffective Team Communication8/23/2020
76GreenClarkClark.Green@dm.comEffective Team Communication - Portal6/11/2021
77HalpertJimJim.Halpert@dm.comEffective Team Communication - Portal8/8/2021
78HalpertJimJim.Halpert@dm.comProject Management4/26/2019
79HalpertJimJim.Halpert@dm.comEmpoloyee Compliance Training2/15/2019
80HalpertJimJim.Halpert@dm.comNegotiation 10111/4/2021
81HalpertJimJim.Halpert@dm.com*Time Management8/30/2018
82HalpertJimJim.Halpert@dm.comCompliance Training4/4/2018
83HalpertJimJim.Halpert@dm.comNegotiation 10110/29/2020
84HalpertJimJim.Halpert@dm.comCompliance Training5/23/2020
85HannonErinErin.Hannon@dm.comEmpoloyee Compliance Training12/13/2019
86HannonErinErin.Hannon@dm.comTeam Project Management9/5/2021
87HannonErinErin.Hannon@dm.comProject Management10/6/2017
88HannonErinErin.Hannon@dm.comConflict Resolution for co-workers1/22/2018
89HannonErinErin.Hannon@dm.comLeadership 20202/25/2019
90HannonErinErin.Hannon@dm.com**Emotional Intelligence
91HannonErinErin.Hannon@dm.comDecision Making3/14/2020
92HannonErinErin.Hannon@dm.comProject Management1/19/2022
93HowardRyanRyan.Howard@dm.com*Time Management11/28/2020
94HowardRyanRyan.Howard@dm.comConflict Resolution3/27/2018
95HowardRyanRyan.Howard@dm.comNegotiation10/27/2018
96HowardRyanRyan.Howard@dm.comEffective Team Communication4/21/2021
97HowardRyanRyan.Howard@dm.comTeam Project Management6/13/2021
98HowardRyanRyan.Howard@dm.comCompliance Training4/29/2019
99HowardRyanRyan.Howard@dm.comConflict Resolution for co-workers5/21/2021
100HowardRyanRyan.Howard@dm.comDecision Making4/23/2020
101HudsonStanleyStanley.Hudson@dm.comEmotional Intelligence3/28/2018
102HudsonStanleyStanley.Hudson@dm.comDecision Making4/29/2020
103HudsonStanleyStanley.Hudson@dm.comDecision Making 20195/7/2018
104HudsonStanleyStanley.Hudson@dm.comProject Management11/17/2019
105HudsonStanleyStanley.Hudson@dm.comLeadership 20204/12/2020
106HudsonStanleyStanley.Hudson@dm.comDecision Making 20197/11/2018
107HudsonStanleyStanley.Hudson@dm.comLeadership12/6/2021
108HudsonStanleyStanley.Hudson@dm.comDecision Making 201912/7/2019
109KapoorKellyKelly.Kapoor@dm.comConflict Resolution5/3/2018
110KapoorKellyKelly.Kapoor@dm.comConflict Resolution for co-workers7/8/2019
111KapoorKellyKelly.Kapoor@dm.comTeam Project Management10/6/2019
112KapoorKellyKelly.Kapoor@dm.comLeadership 20202/6/2018
113KapoorKellyKelly.Kapoor@dm.comEmpoloyee Compliance Training4/24/2020
114KapoorKellyKelly.Kapoor@dm.comStress Management in the workplace2/9/2018
115KapoorKellyKelly.Kapoor@dm.comConflict Resolution for co-workers3/7/2021
116KapoorKellyKelly.Kapoor@dm.comDecision Making11/5/2021
117LevinsonJanJan.Levinson@dm.comProject Management7/5/2021
118LevinsonJanJan.Levinson@dm.comProject Management7/31/2020
119LevinsonJanJan.Levinson@dm.com**Emotional Intelligence1/29/2018
120LevinsonJanJan.Levinson@dm.com**Emotional Intelligence6/18/2020
121LevinsonJanJan.Levinson@dm.comLeadership 20201/4/2022
122LevinsonJanJan.Levinson@dm.com*Time Management10/6/2017
123LevinsonJanJan.Levinson@dm.comTime Management7/28/2020
124LevinsonJanJan.Levinson@dm.comTeam Project Management1/10/2022
125LevinsonJanJan.Levinson@dm.comLeadership2/7/2019
126LewisGabeGabe.Lewis@dm.comConflict Resolution for co-workers1/18/2022
127LewisZacharyZachary.Lewis@dm.comNegotiation1/28/2022
128LewisGabeGabe.Lewis@dm.comEmotional Intelligence3/1/2020
129LewisZacharyZachary.Lewis@dm.comNegotiation11/18/2020
130LewisGabeGabe.Lewis@dm.com*Time Management7/13/2020
131LewisZacharyZachary.Lewis@dm.comTime Management4/6/2021
132LewisGabeGabe.Lewis@dm.comConflict Resolution for co-workers2/11/2022
133LewisZacharyZachary.Lewis@dm.com**Emotional Intelligence7/5/2020
134LewisGabeGabe.Lewis@dm.comEmpoloyee Compliance Training
135LewisZacharyZachary.Lewis@dm.comEmpoloyee Compliance Training12/30/2018
136LewisGabeGabe.Lewis@dm.comProject Management9/14/2019
137LewisZacharyZachary.Lewis@dm.comDecision Making9/26/2017
138LewisGabeGabe.Lewis@dm.comLeadership 20206/16/2020
139LewisZacharyZachary.Lewis@dm.comCompliance Training12/16/2021
140LewisGabeGabe.Lewis@dm.comEmotional Intelligence12/19/2021
141LewisZacharyZachary.Lewis@dm.comDecision Making 20194/21/2019
142MaloneKevinKevin.Malone@dm.comEmpoloyee Compliance Training9/15/2021
143MaloneKevinKevin.Malone@dm.comProject Management10/4/2018
144MaloneKevinKevin.Malone@dm.comStress Management4/21/2020
145MaloneKevinKevin.Malone@dm.comLeadership 202010/10/2017
146MaloneKevinKevin.Malone@dm.comStress Management in the workplace7/8/2019
147MaloneKevinKevin.Malone@dm.comDecision Making 20193/3/2019
148MaloneKevinKevin.Malone@dm.comConflict Resolution12/28/2018
149MaloneKevinKevin.Malone@dm.comStress Management4/26/2018
150MartinAngelaAngela.Martin@dm.com**Emotional Intelligence9/24/2021
151MartinDavidDavid.Martin@dm.comTeam Project Management10/18/2020
152MartinAngelaAngela.Martin@dm.com*Time Management10/1/2020
153MartinDavidDavid.Martin@dm.com**Emotional Intelligence4/13/2018
154MartinAngelaAngela.Martin@dm.comConflict Resolution9/1/2021
155MartinDavidDavid.Martin@dm.comEmotional Intelligence2/28/2020
156MartinDavidDavid.Martin@dm.comEmotional Intelligence2/14/2019
157MartinAngelaAngela.Martin@dm.comTime Management12/12/2017
158MartinDavidDavid.Martin@dm.comEmpoloyee Compliance Training11/24/2021
159MartinAngelaAngela.Martin@dm.comEffective Team Communication - Portal12/13/2020
160MartinDavidDavid.Martin@dm.comEmotional Intelligence12/5/2017
161MartinAngelaAngela.Martin@dm.comCompliance Training6/30/2018
162MartinDavidDavid.Martin@dm.comProject Management3/17/2019
163MartinAngelaAngela.Martin@dm.comEffective Team Communication - Portal3/26/2021
164MartinDavidDavid.Martin@dm.comEffective Team Communication - Portal8/5/2019
165MartinAngelaAngela.Martin@dm.comLeadership9/11/2019
166MartinDavidDavid.Martin@dm.comLeadership5/2/2020
167MartinezOscarOscar.Martinez@dm.comLeadership 202011/3/2017
168MartinezJoseJose.Martinez@dm.comProject Management3/12/2021
169MartinezCarlosCarlos.Martinez@dm.comTime Management3/9/2019
170MartinezOscarOscar.Martinez@dm.comDecision Making 20197/15/2019
171MartinezJoseJose.Martinez@dm.comProject Management1/30/2018
172MartinezCarlosCarlos.Martinez@dm.comLeadership 20203/10/2019
173MartinezOscarOscar.Martinez@dm.comTime Management1/26/2021
174MartinezJoseJose.Martinez@dm.comEffective Team Communication2/22/2019
175MartinezCarlosCarlos.Martinez@dm.comConflict Resolution10/5/2017
176MartinezOscarOscar.Martinez@dm.comLeadership 202011/29/2019
177MartinezJoseJose.Martinez@dm.comDecision Making 20194/30/2020
178MartinezCarlosCarlos.Martinez@dm.comLeadership
179MartinezOscarOscar.Martinez@dm.comNegotiation 1014/24/2021
180MartinezJoseJose.Martinez@dm.comTeam Project Management2/2/2020
181MartinezCarlosCarlos.Martinez@dm.comEmotional Intelligence9/27/2020
182MartinezOscarOscar.Martinez@dm.comEffective Team Communication - Portal12/19/2018
183MartinezJoseJose.Martinez@dm.comEmotional Intelligence7/9/2020
184MartinezCarlosCarlos.Martinez@dm.com**Emotional Intelligence5/19/2019
185MartinezOscarOscar.Martinez@dm.comConflict Resolution5/26/2021
186MartinezJoseJose.Martinez@dm.comStress Management in the workplace3/25/2020
187MartinezCarlosCarlos.Martinez@dm.comEffective Team Communication - Portal1/10/2021
188MartinezOscarOscar.Martinez@dm.comEffective Team Communication4/9/2019
189MartinezJoseJose.Martinez@dm.comDecision Making8/29/2021
190MartinezCarlosCarlos.Martinez@dm.comNegotiation 1017/16/2020
191MillerPetePete.Miller@dm.comProject Management7/28/2020
192MillerPetePete.Miller@dm.comProject Management1/4/2022
193MillerPetePete.Miller@dm.comConflict Resolution for co-workers11/21/2019
194MillerPetePete.Miller@dm.comTime Management12/29/2019
195MillerPetePete.Miller@dm.comNegotiation 1016/16/2019
196MillerPetePete.Miller@dm.comEffective Team Communication - Portal5/31/2020
197MillerPetePete.Miller@dm.comProject Management10/17/2017
198MillerPetePete.Miller@dm.comEffective Team Communication1/18/2020
199MinerCharlesCharles.Miner@dm.comConflict Resolution for co-workers3/3/2019
200MinerAnthonyAnthony.Miner@dm.com*Time Management2/13/2018
201MinerCharlesCharles.Miner@dm.comEmpoloyee Compliance Training7/1/2020
202MinerAnthonyAnthony.Miner@dm.comNegotiation1/4/2020
203MinerCharlesCharles.Miner@dm.comDecision Making3/29/2021
204MinerCharlesCharles.Miner@dm.comDecision Making3/11/2019
205MinerAnthonyAnthony.Miner@dm.comNegotiation 101
206MinerCharlesCharles.Miner@dm.comConflict Resolution12/18/2017
207MinerAnthonyAnthony.Miner@dm.comEffective Team Communication - Portal10/27/2018
208MinerCharlesCharles.Miner@dm.comEffective Team Communication6/29/2019
209MinerAnthonyAnthony.Miner@dm.comDecision Making 20196/12/2018
210MinerCharlesCharles.Miner@dm.comEffective Team Communication10/17/2018
211MinerAnthonyAnthony.Miner@dm.comDecision Making 201911/15/2021
212MinerCharlesCharles.Miner@dm.comConflict Resolution9/29/2018
213MinerAnthonyAnthony.Miner@dm.comTeam Project Management1/15/2021
214MinerCharlesCharles.Miner@dm.comNegotiation 1019/14/2020
215MinerAnthonyAnthony.Miner@dm.comLeadership4/20/2021
216PackerToddTodd.Packer@dm.comConflict Resolution12/25/2020
217PackerToddTodd.Packer@dm.comCompliance Training12/12/2021
218PackerToddTodd.Packer@dm.comEmpoloyee Compliance Training3/29/2018
219PackerToddTodd.Packer@dm.comEmpoloyee Compliance Training10/9/2020
220PackerToddTodd.Packer@dm.comEffective Team Communication - Portal11/9/2021
221PackerToddTodd.Packer@dm.comTeam Project Management10/6/2020
222PackerToddTodd.Packer@dm.comDecision Making
223PackerToddTodd.Packer@dm.comEffective Team Communication - Portal3/29/2018
224PalmerMeredithMeredith.Palmer@dm.comStress Management in the workplace9/29/2020
225PalmerMeredithMeredith.Palmer@dm.comEmpoloyee Compliance Training10/29/2021
226PalmerMeredithMeredith.Palmer@dm.comProject Management7/13/2021
227PalmerMeredithMeredith.Palmer@dm.com**Emotional Intelligence1/19/2022
228PalmerMeredithMeredith.Palmer@dm.comConflict Resolution10/24/2019
229PalmerMeredithMeredith.Palmer@dm.comNegotiation2/18/2020
230PalmerMeredithMeredith.Palmer@dm.comConflict Resolution3/20/2020
231PalmerMeredithMeredith.Palmer@dm.comLeadership 20207/8/2020
232PhilbinDarrylDarryl.Philbin@dm.com*Time Management11/27/2017
233PhilbinDarrylDarryl.Philbin@dm.com*Time Management10/15/2021
234PhilbinDarrylDarryl.Philbin@dm.comStress Management2/11/2022
235PhilbinDarrylDarryl.Philbin@dm.comProject Management10/13/2020
236PhilbinDarrylDarryl.Philbin@dm.comEmpoloyee Compliance Training8/19/2018
237PhilbinDarrylDarryl.Philbin@dm.comStress Management in the workplace10/19/2021
238PhilbinDarrylDarryl.Philbin@dm.comLeadership 202010/1/2021
239PhilbinDarrylDarryl.Philbin@dm.comEmpoloyee Compliance Training7/13/2020
240SchruteDwightDwight.Schrute@dm.comConflict Resolution1/10/2019
241SchruteMoseMose.Schrute@dm.comNegotiation11/12/2020
242SchruteDwightDwight.Schrute@dm.comConflict Resolution4/6/2020
243SchruteMoseMose.Schrute@dm.comConflict Resolution for co-workers4/18/2021
244SchruteDwightDwight.Schrute@dm.comTime Management11/29/2019
245SchruteMoseMose.Schrute@dm.comConflict Resolution8/31/2019
246SchruteDwightDwight.Schrute@dm.com**Emotional Intelligence2/10/2018
247SchruteDwightDwight.Schrute@dm.com**Emotional Intelligence2/28/2021
248SchruteMoseMose.Schrute@dm.comDecision Making 201910/6/2017
249SchruteDwightDwight.Schrute@dm.comLeadership 2020
250SchruteMoseMose.Schrute@dm.comLeadership 20202/8/2020
251SchruteDwightDwight.Schrute@dm.comCompliance Training9/3/2019
252SchruteMoseMose.Schrute@dm.comConflict Resolution4/4/2020
253SchruteDwightDwight.Schrute@dm.comProject Management9/13/2020
254SchruteMoseMose.Schrute@dm.comTime Management7/26/2018
255SchruteDwightDwight.Schrute@dm.comProject Management6/15/2018
256SchruteMoseMose.Schrute@dm.comConflict Resolution12/23/2021
257ScottMichaelMichael.Scott@dm.comStress Management in the workplace12/4/2020
258ScottMichaelMichael.Scott@dm.comConflict Resolution1/20/2019
259ScottMichaelMichael.Scott@dm.comDecision Making 201912/26/2020
260ScottMichaelMichael.Scott@dm.comCompliance Training10/6/2018
261ScottMichaelMichael.Scott@dm.com*Time Management12/16/2017
262ScottMichaelMichael.Scott@dm.comTime Management9/24/2018
263ScottMichaelMichael.Scott@dm.comEmpoloyee Compliance Training12/3/2020
264ScottMichaelMichael.Scott@dm.com*Time Management6/30/2018
265VancePhyllisPhyllis.Vance@dm.com*Time Management9/14/2018
266VancePhyllisPhyllis.Vance@dm.comLeadership
267VancePhyllisPhyllis.Vance@dm.comConflict Resolution for co-workers11/17/2021
268VancePhyllisPhyllis.Vance@dm.comEmotional Intelligence2/11/2020
269VancePhyllisPhyllis.Vance@dm.comEmotional Intelligence1/25/2018
270VancePhyllisPhyllis.Vance@dm.comEmpoloyee Compliance Training5/20/2018
271VancePhyllisPhyllis.Vance@dm.comDecision Making10/29/2018
272VancePhyllisPhyllis.Vance@dm.comTime Management8/1/2019
273VickersDeangeloDeangelo.Vickers@dm.comEffective Team Communication - Portal11/15/2020
274VickersDeangeloDeangelo.Vickers@dm.comEffective Team Communication - Portal7/24/2019
275VickersDeangeloDeangelo.Vickers@dm.comLeadership5/8/2019
276VickersDeangeloDeangelo.Vickers@dm.com*Time Management3/3/2019
277VickersDeangeloDeangelo.Vickers@dm.comEmotional Intelligence1/8/2019
278VickersDeangeloDeangelo.Vickers@dm.comEmpoloyee Compliance Training7/2/2021
279VickersDeangeloDeangelo.Vickers@dm.com**Emotional Intelligence12/29/2017
280VickersDeangeloDeangelo.Vickers@dm.com*Time Management8/18/2021
281WallaceDavidDavid.Wallace@dm.comDecision Making7/27/2021
282WallaceDavidDavid.Wallace@dm.comStress Management2/17/2018
283WallaceDavidDavid.Wallace@dm.comCompliance Training4/17/2019
284WallaceDavidDavid.Wallace@dm.comConflict Resolution5/13/2018
285WallaceDavidDavid.Wallace@dm.comLeadership5/9/2020
286WallaceDavidDavid.Wallace@dm.comConflict Resolution for co-workers1/25/2020
287WallaceDavidDavid.Wallace@dm.comNegotiation3/1/2019
288WallaceDavidDavid.Wallace@dm.comEmpoloyee Compliance Training11/12/2021
Output from Training Database
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Not a VBA solution:
MrExcelPlayground7.xlsx
ABCDEFGHIJKL
1NameEmailLeadershipEffective Team CommunicationProject ManagementNegotiationConflict ResolutionTime ManagementEmotional IntelligenceCompliance TrainingDecision MakingStress Management
2Beesly, PamPam.Beesly@dm.com  5/25/20182/5/20189/25/20191/18/202212/4/20219/14/2020  
3Bernard, AndyAndy.Bernard@dm.com 9/7/202111/12/2021 11/12/2017 12/1/2021 10/23/2021 
4Bertram, NellieNellie.Bertram@dm.com9/25/202010/29/2020 2/17/2018   7/8/201810/28/20187/1/2018
5Bratton, CreedCreed.Bratton@dm.com10/2/2021  7/18/20212/7/202211/11/20199/17/20192/8/2021 5/13/2021
6California, RobertRobert.California@dm.com9/27/20195/10/202010/4/201910/8/20172/4/202010/18/2019    
7Filippelli, KarenKaren.Filippelli@dm.com3/11/2021   10/20/201812/4/20193/29/2018 6/16/20217/13/2018
8Flax, HollyHolly.Flax@dm.com 7/12/2019   5/6/20211/16/20208/31/20198/27/202110/25/2021
9Flenderson, TobyToby.Flenderson@dm.com3/12/20203/5/2019  9/5/2020 3/11/20215/14/201912/31/20196/5/2020
10Green, ClarkClark.Green@dm.com8/19/20216/11/2021  1/27/2022 7/12/2019  5/28/2021
11Halpert, JimJim.Halpert@dm.com 8/8/20214/26/201911/4/2021 8/30/2018 5/23/2020  
12Hannon, ErinErin.Hannon@dm.com2/25/2019 1/19/2022 1/22/2018  12/13/20193/14/2020 
13Howard, RyanRyan.Howard@dm.com 4/21/20216/13/202110/27/20185/21/202111/28/2020 4/29/20194/23/2020 
14Hudson, StanleyStanley.Hudson@dm.com12/6/2021 11/17/2019   3/28/2018 4/29/2020 
15Kapoor, KellyKelly.Kapoor@dm.com2/6/2018 10/6/2019 3/7/2021  4/24/202011/5/20212/9/2018
16Levinson, JanJan.Levinson@dm.com1/4/2022 1/10/2022  7/28/20206/18/2020   
17Lewis, GabeGabe.Lewis@dm.com6/16/2020 9/14/2019 2/11/20227/13/202012/19/2021   
18Lewis, ZacharyZachary.Lewis@dm.com   1/28/2022 4/6/20217/5/202012/16/20214/21/2019 
19Malone, KevinKevin.Malone@dm.com10/10/2017 10/4/2018 12/28/2018  9/15/20213/3/20194/21/2020
20Martin, AngelaAngela.Martin@dm.com9/11/20193/26/2021  9/1/202110/1/20209/24/20216/30/2018  
21Martin, DavidDavid.Martin@dm.com5/2/20208/5/201910/18/2020   2/28/202011/24/2021  
22Martinez, CarlosCarlos.Martinez@dm.com3/10/20191/10/2021 7/16/202010/5/20173/9/20199/27/2020   
23Martinez, JoseJose.Martinez@dm.com 2/22/20193/12/2021   7/9/2020 8/29/20213/25/2020
24Martinez, OscarOscar.Martinez@dm.com11/29/20194/9/2019 4/24/20215/26/20211/26/2021  7/15/2019 
25Miller, PetePete.Miller@dm.com 5/31/20201/4/20226/16/201911/21/201912/29/2019    
26Miner, AnthonyAnthony.Miner@dm.com4/20/202110/27/20181/15/20211/4/2020 2/13/2018  11/15/2021 
27Miner, CharlesCharles.Miner@dm.com 6/29/2019 9/14/20203/3/2019  7/1/20203/29/2021 
28Packer, ToddTodd.Packer@dm.com 11/9/202110/6/2020 12/25/2020  12/12/2021  
29Palmer, MeredithMeredith.Palmer@dm.com7/8/2020 7/13/20212/18/20203/20/2020 1/19/202210/29/2021 9/29/2020
30Philbin, DarrylDarryl.Philbin@dm.com10/1/2021 10/13/2020  10/15/2021 7/13/2020 2/11/2022
31Schrute, DwightDwight.Schrute@dm.com  9/13/2020 4/6/202011/29/20192/28/20219/3/2019  
32Schrute, MoseMose.Schrute@dm.com2/8/2020  11/12/202012/23/20217/26/2018  10/6/2017 
33Scott, MichaelMichael.Scott@dm.com    1/20/20199/24/2018 12/3/202012/26/202012/4/2020
34Vance, PhyllisPhyllis.Vance@dm.com    11/17/20218/1/20192/11/20205/20/201810/29/2018 
35Vickers, DeangeloDeangelo.Vickers@dm.com5/8/201911/15/2020   8/18/20211/8/20197/2/2021  
36Wallace, DavidDavid.Wallace@dm.com5/9/2020  3/1/20191/25/2020  11/12/20217/27/20212/17/2018
Sheet6
Cell Formulas
RangeFormula
C2:L36C2=IFERROR(1/(1/(MAX((FILTER(training!$E$2:$E$288,(training!$C$2:$C$288=$B2)*NOT(ISERR(SEARCH(C$1,training!$D$2:$D$288))),""))))),"")
 
Upvote 0
Quick question: when I plug this formula into my spreadsheet, it opens up a dialog box (attached). I think it's because of the FILTER command, but I'm not sure. What do I do when the box pops up?
 

Attachments

  • Capture.PNG
    Capture.PNG
    134 KB · Views: 14
Upvote 0
You need to change the sheet name "training" in the formula to match your actual sheet name.
 
Upvote 0
FILTER works on my home computer, but not on my work computer. It seems like FILTER is only available with certain versions of Excel. ?? Is there a solution without using FILTER? VBA?
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,037
Members
448,543
Latest member
MartinLarkin

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