Find Jobs
Hire Freelancers

Need an excel expert

$30-250 USD

Teljesítve
Kiadva ekkor: több mint 5 évvel ezelőtt

$30-250 USD

Teljesítéskor fizetve
I have 10k+ rows of data that includes a name, score on a specific measure, and the date when the measure was taken. Some people only took the measure once, whereas others took the measure multiple times. I only need for people who have completed the measure at least twice; for clients who have completed more than 2 measures, I need those clients first and last measure. I included an example below for clarity. So I do not need to retain the data for Client A, but I would need the data for Clients B & C. For Client C, however, I only need the data from 12/01/2015 & 5/22/2017 (the oldest and newest). Does anyone know how I can tackle this problem. Thank you for your time! Example: Client Measure Score Date Taken A 5 9/14/2018 B 2 8/01/2016 B 6 10/12/2017 C 1 12/01/2015 C 4 6/13/2016 C 3 5/22/2017
Projektazonosító: 18000322

A projektről

15 ajánlat
Távolról teljesíthető projekt
Aktiválva: 6 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
Neki odaítélve:
Felhasználó avatár
hi sir, i have very clearly understood the requirement to show only the clients data who have taken the measure at least two times and for the clients who have taken more than two times we have to take the first and last measure to show how much our program benefitted them overall, ready to do right now in excel, thanks
$30 USD 1 napon belül
5,0 (430 értékelés)
6,7
6,7
15 szabadúszó adott átlagosan $98 USD összegű árajánlatot erre a munkára
Felhasználó avatár
Okay understood. Can you please send me the Excel file so I can take a look and do some as sample to show you now. PM me so I can start. Thanks
$155 USD 3 napon belül
5,0 (459 értékelés)
7,5
7,5
Felhasználó avatár
Hello, i am serious freelancer with 100% completion rate and i believe i can help you. I've completed hundreds of excel projects (with both formulas and macros) and i've never had a single problem. Your problem can be solved with a macro and if you want feel free to message me and i will explain step by step how i would solve this problem. Thanks, Milan
$83 USD 0 napon belül
5,0 (610 értékelés)
7,3
7,3
Felhasználó avatár
Hello, You need to sort out people who have completed the measure at least twice and only those clients first and last measure. I can do this using Excel formula. I’m ready to start. Best regards, Hoang
$80 USD 1 napon belül
5,0 (169 értékelés)
7,0
7,0
Felhasználó avatár
Hello? How are you? I have good skills in So I can complete your job in time. Hope to work with you. Thank you.
$155 USD 3 napon belül
4,9 (100 értékelés)
6,8
6,8
Felhasználó avatár
"Hi, I have just gone through your project description and reviewed everything. Yes, I’m able to work as per your instructions in your current project and able to provide accurate and quick service. You know! I’m efficient and experienced data entry worker. If you consider me for this job, I will try my level best to complete your project within our committed deadline. I look forward to hearing from you about the project. Regards"
$30 USD 3 napon belül
4,9 (25 értékelés)
4,9
4,9
Felhasználó avatár
Dear Client, I can score data and complete the task. I have excellent experience of Data entry, MS Office and Web Research for more than 4 Year’s. Never ends up until you are 100% satisfied with each and everything. I have 50+ WPM (Words Per Minute) with 100% Accuracy. I have worked on the similar projects before, so with my interpersonal skills and experience I would be happy to work for you. Best Wishes, Aishwarya Kumari
$30 USD 0 napon belül
5,0 (25 értékelés)
4,1
4,1
Felhasználó avatár
Hello I have done master's in mathematics and statistics and good in excel also so I am one of the suitable candidate for this project. Feel free to contact me. Thanks Prem
$150 USD 3 napon belül
4,6 (13 értékelés)
4,4
4,4
Felhasználó avatár
Hello I can cleanse your data for you as you have described. So that only those that have two scores are present, and where there are more than two scores only the oldest and newest are retained. I can have the cleansed data back to you today. I am a professional programmer, and expert with my excel. Please see my profile to read many great reviews from recent clients. Best Gary
$133 USD 1 napon belül
5,0 (1 értékelés)
3,5
3,5
Felhasználó avatár
Data Entry, Data Processing, Excel, Mathematics, Statistics I think I'm really qualified to go through with that project.
$100 USD 2 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
. I am very fast working with excel.I am very fast working with excel.I am very fast working with excel. I am very fast working with excel
$35 USD 2 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hi. This task appears quite simple. I would import the data into Microsoft Access and then query the data to exclude the rows that are not needed. The rows that meet your criteria would then be exported back to Excel. I have over 40 years of I.T. experience which includes many years of Excel and Access work. I would appreciate the opportunity to perform this work for you.
$105 USD 2 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
I have many years of experience in Excel and data analysis / reporting. Your requirements are straight forward so I am sure I can deliver the results you require.
$72 USD 2 napon belül
0,0 (0 értékelés)
1,3
1,3
Felhasználó avatár
Sir .. I m best you can elect me for your work.. Thank you
$155 USD 3 napon belül
0,0 (0 értékelés)
0,0
0,0

Az ügyfélről

UNITED STATES zászlója
Austin, United States
5,0
5
Fizetési mód hitelesítve
Tagság kezdete: okt. 21, 2018

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.