Need an excel expert

$30-250 USD

Complété

Publié

il y a plus de 5 ans

$30-250 USD

Payé lors de la livraison

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

N° de projet : 18000322

Concernant le projet

15 propositions

Projet à distance

Actif à il y a 6 ans

Cherchez-vous à gagner de l'argent ?

Adresse e-mail

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais

Soyez payé pour votre travail

Surlignez votre proposition

Il est gratuit de s'inscrire et de faire des offres sur des travaux

Décerné à :

@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 en 1 jour

5,0

(430 commentaires)

6,7

15 freelances proposent en moyenne $98 USD pour ce travail

@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 en 3 jours

5,0

(459 commentaires)

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 en 0 jour

5,0

(610 commentaires)

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 en 1 jour

5,0

(169 commentaires)

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 en 3 jours

4,9

(100 commentaires)

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 en 3 jours

4,9

(25 commentaires)

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 en 0 jour

5,0

(25 commentaires)

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 en 3 jours

4,6

(13 commentaires)

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 en 1 jour

5,0

(1 commentaire)

3,5

@abualkhier

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

$100 USD en 2 jours

0,0

(0 commentaires)

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 en 2 jours

0,0

(0 commentaires)

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 en 2 jours

0,0

(0 commentaires)

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 en 2 jours