“The Email Puzzle”

Moinul, an enthusiastic HR intern, was tasked with generating unique email addresses for the new employees of a multinational tech company. With hundreds of employees joining from different countries, Moinul knew he’d have to work smart to complete this daunting task on time. He glanced at the Excel sheet filled with the names, joining years, unique IDs, and company details. 

Moinul decided to use Excel’s formula magic to automate the process. But what was the right formula to combine all those elements into the perfect email format? He wanted a formula that would produce emails like “<PRESIDIO_ANONYMIZED_EMAIL_ADDRESS>” and “<PRESIDIO_ANONYMIZED_EMAIL_ADDRESS>” at the click of a button.

What should Moinul type to generate the email addresses in the correct format using the data in his Excel sheet?


Email format example:

     <PRESIDIO_ANONYMIZED_EMAIL_ADDRESS>
    <PRESIDIO_ANONYMIZED_EMAIL_ADDRESS>
    <PRESIDIO_ANONYMIZED_EMAIL_ADDRESS>
    <PRESIDIO_ANONYMIZED_EMAIL_ADDRESS>
    <PRESIDIO_ANONYMIZED_EMAIL_ADDRESS>

The csv file has 9 columns:
First Name
Taylor
Avery
Avery
Casey
Jane
Casey
Chris
Alex
Avery
Casey
Jane
Alex
Morgan
Alex
Jordan
Avery
Avery
Riley
Riley
John
Jane
Avery
Taylor
Casey
Jane
Taylor
Chris
Casey
Jordan
Avery
Jordan
Jane
Alex
Chris
Avery
Avery
Jane
Alex
Casey
Morgan
Riley
Riley
Riley
Taylor
John
Alex
Morgan
Taylor
Morgan
Jane
Morgan
John
Jane
John
Alex
Alex
Jordan
Chris
Riley
Taylor
Avery
Chris
Jane
Morgan
Avery
Morgan
Alex
Alex
Alex
Taylor
Riley
Avery
Jane
Alex
Jane
Riley
Jane
John
Avery
Riley
Taylor
Morgan
Riley
John
Taylor
Jordan
Chris
Alex
Chris
Alex
Morgan
Jane
Morgan
Avery
Casey
Casey
John
Chris
Casey
John

Last Name
Brown
Anderson
Miller
Brown
Garcia
Martinez
Miller
Martinez
Brown
Davis
Brown
Miller
Anderson
Johnson
Martinez
Davis
Anderson
Doe
Brown
Brown
Miller
Davis
Brown
Anderson
Davis
Brown
Smith
Taylor
Anderson
Doe
Johnson
Taylor
Doe
Taylor
Martinez
Smith
Smith
Martinez
Davis
Smith
Miller
Miller
Taylor
Doe
Doe
Doe
Miller
Doe
Garcia
Garcia
Garcia
Smith
Brown
Martinez
Anderson
Garcia
Garcia
Doe
Johnson
Miller
Martinez
Smith
Brown
Garcia
Johnson
Johnson
Taylor
Johnson
Johnson
Brown
Smith
Johnson
Taylor
Anderson
Smith
Taylor
Johnson
Anderson
Martinez
Doe
Miller
Smith
Davis
Martinez
Miller
Garcia
Doe
Martinez
Brown
Garcia
Martinez
Brown
Doe
Davis
Doe
Davis
Anderson
Garcia
Garcia
Johnson

Year of Joining
2016
2004
2020
2016
2009
2022
2011
2015
2003
2005
2014
2017
2012
2010
2016
2016
2005
2006
2006
2009
2016
2015
2000
2000
2008
2010
2020
2015
2011
2015
2014
2014
2007
2010
2011
2023
2016
2018
2016
2002
2021
2015
2009
2002
2003
2012
2012
2015
2004
2015
2013
2001
2013
2000
2009
2007
2009
2017
2004
2007
2020
2011
2007
2022
2017
2001
2021
2018
2007
2016
2020
2023
2016
2015
2014
2016
2018
2008
2010
2008
2000
2014
2020
2015
2004
2009
2002
2023
2009
2003
2017
2016
2017
2022
2019
2006
2018
2009
2021
2010

Unique ID
3703
2388
4496
2821
2389
8794
1771
8835
8881
9390
9611
3864
7282
4035
7282
1274
1819
4054
5586
4855
9324
2388
8881
3287
6534
8881
4855
7710
9432
4855
2388
3657
9243
6662
4855
9654
1704
3703
4741
7261
8646
1467
6534
5150
1757
5378
3703
5419
3067
5378
9460
5581
8902
2478
8881
2343
5378
3287
5581
7246
9719
4855
5378
5150
8542
2575
5419
1684
8881
6380
9243
9533
3996
1357
1757
7710
5150
3996
4855
3657
1971
2821
1916
5150
6662
9611
5898
9324
3657
3657
7710
9390
9611
7314
3345
8646
8990
8881
9533
8873

Company Name
Quantum Leap
Data Innovators
Data Innovators
Synergy Solutions
Quantum Leap
Synergy Solutions
Tech Titans
Tech Titans
Quantum Leap
Data Innovators
Quantum Leap
Data Innovators
Quantum Leap
Synergy Solutions
Tech Titans
Data Innovators
Synergy Solutions
Tech Titans
Synergy Solutions
Synergy Solutions
Data Innovators
Tech Titans
Quantum Leap
Tech Titans
Synergy Solutions
Quantum Leap
Synergy Solutions
Quantum Leap
Tech Titans
Synergy Solutions
Synergy Solutions
Quantum Leap
Data Innovators
Synergy Solutions
Synergy Solutions
Synergy Solutions
Quantum Leap
Data Innovators
Synergy Solutions
Synergy Solutions
Tech Titans
Quantum Leap
Quantum Leap
Data Innovators
Tech Titans
Data Innovators
Synergy Solutions
Tech Titans
Quantum Leap
Tech Titans
Data Innovators
Synergy Solutions
Data Innovators
Synergy Solutions
Synergy Solutions
Synergy Solutions
Quantum Leap
Data Innovators
Synergy Solutions
Synergy Solutions
Synergy Solutions
Synergy Solutions
Synergy Solutions
Data Innovators
Tech Titans
Tech Titans
Synergy Solutions
Data Innovators
Data Innovators
Quantum Leap
Tech Titans
Synergy Solutions
Synergy Solutions
Tech Titans
Data Innovators
Tech Titans
Quantum Leap
Synergy Solutions
Quantum Leap
Synergy Solutions
Synergy Solutions
Data Innovators
Quantum Leap
Data Innovators
Data Innovators
Tech Titans
Tech Titans
Synergy Solutions
Synergy Solutions
Tech Titans
Synergy Solutions
Data Innovators
Data Innovators
Tech Titans
Tech Titans
Tech Titans
Quantum Leap
Data Innovators
Synergy Solutions
Synergy Solutions

Company Initial
ql
diu
diu
ss
ql
ss
tt
tt
ql
diu
ql
diu
ql
ss
tt
diu
ss
tt
ss
ss
diu
tt
ql
tt
ss
ql
ss
ql
tt
ss
ss
ql
diu
ss
ss
ss
ql
diu
ss
ss
tt
ql
ql
diu
tt
diu
ss
tt
ql
tt
diu
ss
diu
ss
ss
ss
ql
diu
ss
ss
ss
ss
ss
diu
tt
tt
ss
diu
diu
ql
tt
ss
ss
tt
diu
tt
ql
ss
ql
ss
ss
diu
ql
diu
diu
tt
tt
ss
ss
tt
ss
diu
diu
tt
tt
tt
ql
diu
ss
ss

Company Type
incorporated
incorporated
incorporated
organization
organization
incorporated
network
network
incorporated
commercial
organization
organization
network
network
commercial
commercial
network
network
network
network
incorporated
commercial
commercial
incorporated
commercial
commercial
network
network
network
commercial
commercial
organization
incorporated
commercial
commercial
incorporated
incorporated
organization
organization
commercial
commercial
incorporated
commercial
commercial
organization
network
commercial
organization
network
network
organization
network
network
network
organization
network
incorporated
commercial
commercial
commercial
network
network
network
incorporated
commercial
organization
commercial
commercial
commercial
incorporated
organization
network
commercial
network
network
incorporated
incorporated
network
commercial
network
network
network
organization
organization
organization
commercial
network
commercial
network
incorporated
commercial
commercial
organization
incorporated
incorporated
incorporated
incorporated
organization
incorporated
incorporated

Country
pakistan
bangladesh
pakistan
bangladesh
bangladesh
pakistan
usa
usa
usa
pakistan
bangladesh
pakistan
usa
pakistan
pakistan
usa
usa
pakistan
usa
usa
pakistan
pakistan
bangladesh
usa
usa
usa
pakistan
usa
pakistan
bangladesh
bangladesh
bangladesh
bangladesh
pakistan
usa
bangladesh
usa
bangladesh
usa
pakistan
usa
bangladesh
pakistan
bangladesh
bangladesh
usa
bangladesh
pakistan
pakistan
bangladesh
usa
usa
bangladesh
bangladesh
bangladesh
pakistan
pakistan
bangladesh
bangladesh
bangladesh
bangladesh
usa
usa
bangladesh
bangladesh
usa
usa
bangladesh
pakistan
usa
bangladesh
bangladesh
bangladesh
bangladesh
pakistan
bangladesh
bangladesh
pakistan
bangladesh
bangladesh
pakistan
usa
bangladesh
usa
usa
usa
pakistan
pakistan
bangladesh
pakistan
bangladesh
bangladesh
usa
usa
bangladesh
usa
bangladesh
bangladesh
bangladesh
bangladesh