cansevin
asked on
Pull out Employee name
TestforExpert.xlsxTestforExpert.xlsxI need to pull out the employee name from a column of data. Attached is the file. On Sheet 1 Column A is a list of data (all similar format). On the 2nd sheet "Employees" is a list of our 7 employee's.
In column B on Sheet 1 I would like to have the Employee that is listed in column A. Note: There is always only 1 employee listed. As we grow as a company and add employee's, I would simply add the employee name to Sheet 2 and it would work for new employee's.
In column B on Sheet 1 I would like to have the Employee that is listed in column A. Note: There is always only 1 employee listed. As we grow as a company and add employee's, I would simply add the employee name to Sheet 2 and it would work for new employee's.
There's no attachment.
ASKER
Sorry - just uploaded it.
As I suspected and commented in your previous question, here's the next section to extract.
As I suggested in your previous question, if you give the whole question in one go it might make the solution simpler.
As I suggested in your previous question, if you give the whole question in one go it might make the solution simpler.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@Neeraj - cool array formula!!
Might be able to use that instead of my suggestion to overcome the missing brackets on client names.
@cansevin - can the employee name get into the report if not already an employee and on the Employee list?? In other words can there be a name on the report that isn't in the Employee list.?
Might be able to use that instead of my suggestion to overcome the missing brackets on client names.
@cansevin - can the employee name get into the report if not already an employee and on the Employee list?? In other words can there be a name on the report that isn't in the Employee list.?
Thanks Rob!
Updated file attached, using Neeraj's suggestion to extract Employee name and then the result of that to identify the Client name and the contents of the brackets after the client name. Updated formula in column N which would replace columns G & H.
NB: Neeraj's suggestion is an array formula, when entering an array formula confirm with "Shift + Ctrl + Enter", rather than just Enter.
TestforExpert.xlsx
NB: Neeraj's suggestion is an array formula, when entering an array formula confirm with "Shift + Ctrl + Enter", rather than just Enter.
TestforExpert.xlsx
Also, if you have a list of client names, you could use the same array formula method for extracting the client name.
ASKER
Wow, very impressive from both. Really appreciate your guys help. Have a wonderful day! You made my morning.
Updated file attached. I created a client list from the values that I had already extracted and then used the same array formula method on that list to extract client name.
TestforExpert.xlsx
TestforExpert.xlsx