Need an excel expert

$30-250 USD

Slutfört

Publicerad

över fem år sedan

$30-250 USD

Betalning vid leverans

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

Om projektet

15 anbud

Distansprojekt

Senaste aktivitet sex år sedan

Ute efter att tjäna lite pengar?

E-postadress

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram

Få betalt för ditt arbete

Beskriv ditt förslag

Det är gratis att registrera sig och att lägga anbud på uppdrag

Tilldelad till:

@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 Om 1 dag

5,0

(430 omdömen)

6,7

15 frilansar lägger i genomsnitt anbud på $98 USD för detta uppdrag

@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 Om 3 dagar

5,0

(459 omdömen)

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 Om 0 dag

5,0

(610 omdömen)

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 Om 1 dag

5,0

(169 omdömen)

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 Om 3 dagar

4,9

(100 omdömen)

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 Om 3 dagar

4,9

(25 omdömen)

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 Om 0 dag

5,0

(25 omdömen)

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 Om 3 dagar

4,6

(13 omdömen)

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 Om 1 dag

5,0

(1 omdöme)

3,5

@abualkhier

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

$100 USD Om 2 dagar

0,0

(0 omdömen)

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 Om 2 dagar

0,0

(0 omdömen)

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 Om 2 dagar

0,0

(0 omdömen)

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 Om 2 dagar