Find Jobs
Hire Freelancers

create an excel sheet that can extract data based on three variables comparing two datasets

£10-20 GBP

Ditutup
Dibuat lebih dari 5 tahun yang lalu

£10-20 GBP

Dibayar ketika dikirim
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.
ID Proyek: 17275471

Tentang proyek

38 proposal
Proyek remot
Aktif 6 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
38 freelancer menawar dengan rata-rata £28 GBP untuk pekerjaan ini
Avatar Pengguna
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 help you with confidence and satisfying results... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Data Entry, Data Processing, Excel, Visual Basic We have worked on 350+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
£31 GBP dalam 1 hari
4,9 (604 ulasan)
8,5
8,5
Avatar Pengguna
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
£16 GBP dalam 1 hari
4,7 (483 ulasan)
8,0
8,0
Avatar Pengguna
I am proficient with excel macro/VBA development, I can write the macro to extract the data as requested in your specification, if you are interested feel free to message me, looking forward to chat further for a quick turnaround solution and work on your project
£20 GBP dalam 1 hari
5,0 (181 ulasan)
7,7
7,7
Avatar Pengguna
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
£40 GBP dalam 1 hari
5,0 (342 ulasan)
7,5
7,5
Avatar Pengguna
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.
£20 GBP dalam 1 hari
5,0 (192 ulasan)
7,1
7,1
Avatar Pengguna
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 required at the click of a button. Being a full time freelancer working exclusively on Excel based projects, I work on developing macros every single day. I have 18 years experience in using Excel as part of my daily work life. Over the last 24 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. Have a Great Week Ahead! Srinivasan Krishnamoorthi
£20 GBP dalam 1 hari
5,0 (260 ulasan)
7,2
7,2
Avatar Pengguna
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.
£20 GBP dalam 1 hari
4,8 (192 ulasan)
6,7
6,7
Avatar Pengguna
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 done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, PYTHON, WEKA, TABLEAU and EXCEL tools like machine learning, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash
£100 GBP dalam 1 hari
4,7 (95 ulasan)
6,9
6,9
Avatar Pengguna
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. 3. Can complete on time with good quality and on time. 4. Experienced MBA Finance as well.
£50 GBP dalam 1 hari
4,7 (98 ulasan)
6,4
6,4
Avatar Pengguna
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 (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API. You can see the reviews of the same in my profile
£40 GBP dalam 1 hari
4,9 (95 ulasan)
6,1
6,1
Avatar Pengguna
Hi, I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and charts, macros and VBA scripts, automatic calculation sheets, automatic simulators and charts drawing) as an Industrial Engineer at Michelin Romania. I am always keen to improve my work quality and productivity and, to achieve these goals, I made complex Excel sheets to automate my tasks and eliminate errors. I can solve your problem with pivot table if your tables have column with the same data. I will be pleased to help you with your project and I am sure you will be satisfied with my professionalism and the quality of my work. Best regards, Florin Enache.
£20 GBP dalam 2 hari
5,0 (23 ulasan)
5,7
5,7
Avatar Pengguna
- Can get compared the WCtable & INCtable’ based on - Name of the client - Name of the person they dealt with based on Assigned to & Call data columns. - And the times of interactions within 1 Hour. This can be implemented using the logic with a simple button click. - Can get completed in a day or 2. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables
£100 GBP dalam 2 hari
4,7 (53 ulasan)
6,1
6,1
Avatar Pengguna
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
£38 GBP dalam 2 hari
5,0 (38 ulasan)
5,0
5,0
Avatar Pengguna
Available Immediately | MS Excel Expert | MBA | Assured accuracy and minimum turnaround time | VBA Champion Waiting for your message!
£23 GBP dalam 1 hari
5,0 (10 ulasan)
4,6
4,6
Avatar Pengguna
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 finish it FAST...
£18 GBP dalam 1 hari
4,6 (16 ulasan)
4,5
4,5
Avatar Pengguna
Greetings, It is expected for the VLOOKUP to fail because it does not consider the future entries in a column. You mentioned an attachment but I can't see it, however by your explanation I believe this can be solved with an array formula. I am at your disposal to discuss details on chat, please do not hesitate to contact me even if offline since I am on mobile 24/7. Thanks for the attention.
£17 GBP dalam 1 hari
5,0 (11 ulasan)
3,8
3,8
Avatar Pengguna
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
£15 GBP dalam 0 hari
4,8 (6 ulasan)
3,2
3,2
Avatar Pengguna
Dear Sir/Madam, Please consider my offer for this project. I can do it in few hours. BR, Stoyan ................................................................
£20 GBP dalam 1 hari
5,0 (6 ulasan)
2,5
2,5
Avatar Pengguna
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 the buyer requires the desired result and I am willing to provide those desired result. At the end, the satisfaction of the customer is of utmost importance. Kindly see my proposal and we can discuss further
£10 GBP dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
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.
£13 GBP dalam 2 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera UNITED KINGDOM
United Kingdom
0,0
0
Memverifikasi Metode pembayaran
Anggota sejak Jul 2, 2018

Verifikasi Klien

Pekerjaan lain dari klien ini

VBA help for userform
£10-20 GBP
Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.