Possible to use VBA to summarise a data table in order of data entry?

[Peter1986]

Hi,

Please can I get advice on whether it is possible to use VBA to create a summary table from a 2 column dataset as follows:

• The input data is a simple list of integer 'values' between 1 and 15.
• The output data should count the number of zero values in a row or non-zero values in a row, give the start and end point of those values, the max of those values then once the value changes (to zero or back to non-zero), start counting again. Please see the image below.
• 
  
  
• So in the example above, the first three values are '0', so the first entry in the output states that the value of 0 occurs between the first and third entry, the fourth to seventh value are non zero and the max is 5, the 8th to 10th values are 0, etc,

I am a 3rd year engineering student and have a large dataset (up to 100,000 rows) to sort, and hence any advice on whether this is likely to be possible would be greatly appreciated.

Many Thanks in advance

Peter

 

[Fluff]

Duplicate Refine VBA code to summarise by max values

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).