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
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
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
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
"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"
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
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
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
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.
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.