T
toy4x4
Hope this is the right forum 
I have a spreadsheet with a long list of names that I have to go
through and pick the employees that are mine. What I'm trying to do is
simplify this by creating a find formula(or multiple) that will
automatically populate the column where I indicate they are mine.
An example. I have Column A that is where I put my name to indicate the
employee belongs to me. I need to populate this with toy4x4 if they are
my employee.
Column B contains the employee first and last names and there is no
rhyme or reason to the format of their name in this column.
I can do a =find("Smith",b1) and it returns a 7 which is the starting
point in the string for that last name.
Problem is I have 17 employees. So I need to find "Smith", "Jones",
"Brown", "White", etc
I have to do this monthly and in about 15 spreasheets so I'm looking
for an easy cut and paste method.
Thanks in advance!!
I have a spreadsheet with a long list of names that I have to go
through and pick the employees that are mine. What I'm trying to do is
simplify this by creating a find formula(or multiple) that will
automatically populate the column where I indicate they are mine.
An example. I have Column A that is where I put my name to indicate the
employee belongs to me. I need to populate this with toy4x4 if they are
my employee.
Column B contains the employee first and last names and there is no
rhyme or reason to the format of their name in this column.
I can do a =find("Smith",b1) and it returns a 7 which is the starting
point in the string for that last name.
Problem is I have 17 employees. So I need to find "Smith", "Jones",
"Brown", "White", etc
I have to do this monthly and in about 15 spreasheets so I'm looking
for an easy cut and paste method.
Thanks in advance!!