create an excel sheet that can extract data based on three variables comparing two datasets
£10-20 GBP
Maksettu toimituksen yhteydessä
I am looking for help creating a spreadsheet that will enable me to extract a set of data after comparing three values.
I have attached a sample spreadsheet which I will refer to otherwise I confuse even myself when trying to explain it.
I have two sets of a data a list of times a client called (entered into the ‘WCtable’ table on the ‘Call Data’ sheet) and a list of interactions that were logged for them entered into the ‘INCtable’ table on the reference Data sheet.
There are three things I need to compare to filter out the results I need.
• The name of the client needs to match from the ‘Opened by’ Column on the ‘Call Data’ Sheet with the ‘requester’ column on Sheet ‘Reference Data’
• The name of the person they dealt with needs to also match this is the ‘Assigned to’ column on the ‘Call Data’ Sheet and the ‘opened by’ column on Sheet ‘Reference Data’
• The times of the interactions should be within say 1 Hour of each other so the ‘Opened’ Columns on both sheets.
I have tried doing this with VLookup (failed attempt on the hidden ‘Ignore’ Sheet in the workbook.) But this only returns the first value it finds and some of the clients have more than one and I’m really struggling to think of a straightforward way of trying to marry the instances up other than a lot of nested IF statements but I’m not sure if that will just look for the first value in the column.
Projektin tunnus: #17275471
Tietoa projektista
38 freelanceria on tarjonnut keskimäärin £28 tähän työhön
Hi there..... Warm Greetings We came along with your request for create an excel sheet that can extract data based on three variables comparing two datasets and we reviewed your project description. We'd like to Lisää
Hello there! This is a basic task which can be done using tools in Excel. We have completed Various similar tasks effectively. Please reply to my bid so that we can discuss further. Thanks Brad
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.
Attachment missing! Greetings! It would be easier to implement this requirement (extracting data based on 3 different parameters) using macro. I can come up with a macro using which the data can be extracted as r Lisää
Dear Sir, Greetings. We need to use either index, match, dynamic filter or nested if. I could complete one to show you. Plz let me know if you are interested. Thank you.
Hi I am a very experienced statistician and data scientist. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have do Lisää
1. Expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Lisää
I have excellent command on MS Excel formulas and VBA. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and place bet automatically on betfair ( Lisää
I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, chart, advance formulas, formatting, macros, etc. thanks
Available Immediately | MS Excel Expert | MBA | Assured accuracy and minimum turnaround time | VBA Champion Waiting for your message!
will do sir vlookup I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start and fin Lisää
Hey, I am an excel expert. I am best at VBA, FORMULA,, MACROS. I have read the description and I can do this job easily with 100% accuracy. I have done similar projects before . Thanks
Dear Sir/Madam, Please consider my offer for this project. I can do it in few hours. BR, Stoyan ................................................................
Hello, I have seen your proposal and I am willing to do the job as I have a lot of experience with Microsoft Excel as I have studied courses which master my skills in it. I want to do this job because in my opinion th Lisää
Couldn't find your attached excel sheet. But we are expert in excel so surely will able to help you. We focus and quality and we value time.