Excel data count project

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.

Evner: C++ Programmering, Dataindførsel, Databehandling, Excel, Visual Basic

Se mere: image excel data entry project, pdf excel data entry project, web based vba excel data processing project, pdf excel data conversion project, unable change data excel 2007 locked project view, import excel data project macro, project excel data macro, business project status summary excel formats, export excel data project using macro, excel 2003 count multiple data formats, excel data entry project, data entry project excel vba, excel data entry count, excel inventory count project plan, excel data mining project

Om arbejdsgiveren:
( 0 bedømmelser ) United Kingdom

Projekt ID: #16470119

115 freelancers are bidding on average £367 for this job


Hello Sir, My name is Jay and I'm an Expert Excel and VBA programmer on and have been featured by the freelancer community ( Flere

£300 GBP in 2 dage
(561 bedømmelser)

Hi, Dear Employer! How are you? I am really interested in your project. I have enough experience on python, C/C++, C#, java programming. I am 100% sure i can satisfy your requirements perfectly. User-Friendly Int Flere

£555 GBP in 10 dage
(88 bedømmelser)

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 Flere

£250 GBP in 4 dage
(325 bedømmelser)

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

£250 GBP in 2 dage
(209 bedømmelser)

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 Flere

£350 GBP in 10 dage
(242 bedømmelser)

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 Flere

£250 GBP på 1 dag
(182 bedømmelser)

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am ser Flere

£263 GBP in 10 dage
(63 bedømmelser)

Hi Sir, I am ready to work for you.I have experience in C/C++, python , java, PHP and, MySQL. please see some of my works also check my reviews you will get better idea about my skill.I deliver quality work within tim Flere

£250 GBP in 5 dage
(105 bedømmelser)

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 Flere

£250 GBP in 5 dage
(164 bedømmelser)

Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've completed hundreds of excel projects (automation VBA projects), and i've never had a single problem. IF you are interested in work Flere

£250 GBP på 1 dag
(357 bedømmelser)

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

£300 GBP in 4 dage
(94 bedømmelser)

Hi there,I am Miljan,Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the ag Flere

£250 GBP in 2 dage
(55 bedømmelser)

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.

£500 GBP in 10 dage
(45 bedømmelser)

I am very proficient in c and c++. I have 16 years c++ developing experience now, and have worked for more than 6 years. My work is online game developing, and mainly focus on client side, using c++ under windows envir Flere

£250 GBP in 5 dage
(80 bedømmelser)

Hello. Thank you for your kind post. I read through your job description and I'm sure I'll give u the perfect results. As you see, I've strong background in Algorithm & Programming. Especially I'm very familiar with C/ Flere

£250 GBP på 1 dag
(14 bedømmelser)

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 Flere

£250 GBP in 5 dage
(14 bedømmelser)

Hello. I checked your Excel file and read your [url removed, login to view] need a perfect dashboard for track your results by data in columns A, B and C, I can do your project in less than 3 days according to your description w Flere

£400 GBP in 3 dage
(68 bedømmelser)

Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll do your current Ms Excel Flere

£555 GBP in 10 dage
(29 bedømmelser)

Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating Strings and creating consolidated report. I have done th Flere

£250 GBP in 3 dage
(70 bedømmelser)

hello,how are you. i read your bid carefully. i am c/c++, vba expert and have full experience for 10 years. c/c++, vba language is my top skill. i can provide most quality and high speed. if you want to success, pl Flere

£800 GBP in 10 dage
(3 bedømmelser)