Phoenix - Your AI AssistantExcel Formulas required
- Posted:
- Proposals: 69
- Remote
- #2776511
- Completed
London 
Description
Experience Level: Entry
Please see attached excel file.
I would like you to design a formula to extract data from Sheet 1 and place it in Sheet 2. I have placed examples of the data into Sheet 2 manually just to illustrate the information I would like collected.
I need to be able to use this in another excel document with 100's of contacts but I cannot show you that document as the data is confidential.
The online forms filled in by people shows their name and job description. I would like the description to go in column B, the first word of the description in column A (usually their first name) and an email address (if given) in column C.
I can pay quickly once this is done.
Thank you for taking the time to look at my job.
I would like you to design a formula to extract data from Sheet 1 and place it in Sheet 2. I have placed examples of the data into Sheet 2 manually just to illustrate the information I would like collected.
I need to be able to use this in another excel document with 100's of contacts but I cannot show you that document as the data is confidential.
The online forms filled in by people shows their name and job description. I would like the description to go in column B, the first word of the description in column A (usually their first name) and an email address (if given) in column C.
I can pay quickly once this is done.
Thank you for taking the time to look at my job.
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Aminur,
I have a question regarding the excel file. I want to know if the rows to be extracted to Sheet2 from Sheet1 would be highlighted as it is in the attached sample file? -
Hi, Would you like to check a sample Excel File ?