Excel data count project
£250-750 GBP
Paid on delivery
We would like to understand how many delivered and failed entries occurred after a specific point on a per customer basis.
The data consists of three columns. Column A is the customer who has several rows associated with them. Column B indicates if the entry is delivered or failed. Column C indicates the date and time of each entry which is sorted by oldest to newest.
For each customer we would like to determine after 10 failed entries in succession how many delivered entries occurred and how many failed entries occurred. We would like this repeated for 20 failed entries and 30 failed entries in succession.
For example Customer A has 12 rows of failed entries, then 18 rows of delivered entries, then 4 rows of failed entries, then 3 rows of delivered entries. The result would be Customer A has 21 delivered entries and 4 failed entries. If applying the 20 failed message search Customer A would not be counted.
In summary we would like to know the total number of customers, total number of failed entries, and total number of successful entries for the 3 searches (10 failed entries, 20 failed entries, and 30 failed entries.
An example of the data is attached. There are 6 spreadsheets sharing approx. 3m entries.
Project ID: #16470119
About the project
Awarded to:
Hello Sir, My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelance More
88 freelancers are bidding on average £356 for this job
Hi there..... Warm Greetings We came along with your request for Excel data count project and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have profe More
Hi, I ll code an Excel VBA macro where you will select the input file to be treated and the macro will load the data and make the calculations you mentionned and generate a report. Ready to start. Thanks
Hello , I have read your project description, checked the file and understood your requirement clearly. I am an excel Expert VBA Expert. I can count the data automatically by developing a program in Visual basic.I can More
I can do it for you quickly and exactly . I have finished great than 90 VBA project in this site. Please contact me for saving your time
Hi: I have reviewed the project details and understand that you a script that can count the number of times an event occurs. The event will be X failed entries in succession. The value of X will be variable and will be More
How are you? I have much experiences in handling excel with C++. I am interested in your project. Let's contact and discuss with each other. Thanks.
Dear Sir/Madam, I red your project description and went though the sample file, and would like to say that I can do this task perfectly for you. You may refer my profile to see more details about me and my reliabilit More
Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, More
Hi There, I am good in excel related task. I can do this let's chat more and discuss about the project. Best REgards, Prakash
Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can do More
I have excellent command on MS Excel. I have understood your requirement and achieve the result for the customers and failed entries as mentioned. I have completed complex projects in Excel before . For instance - More
hello, I read your project description, and I understand it. I can complete your Excel project perfectly. Let's chat with me now. Best Regards
Hi, Thanks for posting your requirement. I think I am the best person to do this job. Checked attached file and I think I can handle it pretty easily. I have an extensive knowledge of data processing, visual More