Need an excel expert

$30-250 USD

Completed

Posted

over 5 years ago

$30-250 USD

Paid on delivery

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

Project ID: 18000322

About the project

15 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@rohitagarberg

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 in 1 day

5.0

(430 reviews)

6.7

15 freelancers are bidding on average $98 USD for this job

@Motiurlaw

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 in 3 days

5.0

(459 reviews)

7.5

@MimiFL

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 in 0 day

5.0

(610 reviews)

7.3

@hdlong66

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 in 1 day

5.0

(169 reviews)

7.0

@polarjin2017

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 in 3 days

4.9

(100 reviews)

6.8

@dataexplorer

"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 in 3 days

4.9

(25 reviews)

4.9

@Aishwaryakumari

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 in 0 day

5.0

(25 reviews)

4.1

@hemantjhalani

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 in 3 days

4.6

(13 reviews)

4.4

@GaryMoylan

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 in 1 day

5.0

(1 review)

3.5

@abualkhier

Data Entry, Data Processing, Excel, Mathematics, Statistics I think I'm really qualified to go through with that project.

$100 USD in 2 days

0.0

(0 reviews)

0.0

@Lady28Silvera

. 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 in 2 days

0.0

(0 reviews)

0.0

@ozgunner

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 in 2 days

0.0

(0 reviews)

0.0

@rstapleton6

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 in 2 days