Problems on Implementing do..until on excel spreadsheet

[soldout2]

Hi all! Suppose I have following data :

133.65
137.25
135.78
132.24
130.45
131.99
135.88
136.06
130.23
136.61
133.59
136.54
132.91
139.61
133.19
132.36
133.15
133.59
135.78
135.78
137.27
137.44
133.77
131.96
135.68
138.40
137.53
134.36
139.16
132.70

excel.jpg

I wish the excel could tell me what range of value could divide these 30 data into groups with exactly 5 data per group.

I have an idea on this but I don't know how to command it into VBA language. The logic is here:

whenever a cell which shows "counts" is not equal to 5, it add 0.1 to the cells in left hand side, which represent a range.

[AntrobusJ]

Sorry, I'm not sure I understand what you mean.
In worksheet_change, could you not do this?

Please Login or Register  to view this content.

[soldout2]

I tried these code but it seems works one time only? it ends when 0.1 is added.

I found that there should be an easier way. May u help?

First sort these 30 data in ascending order, then the range is the cell value of 5th,10thcell..

[AntrobusJ]

Thank you for answering. But sorry where should I put these code? I am new

In the VB Editor, you should see the sheet your using to hold this data. If you double click on that sheet, you will see two drop downs.
in the first drop down, select 'Worksheet'. In the second drop down, select 'Change'.

Paste the code there. I am not sure if this code answers your original question as I'm unsure what you actually need.

[soldout2]

What I need is like this picture:
excel2.jpg

each range of value consists 5 data points

[AntrobusJ]

Its a bit hard to understand what you want without knowing the meaning behind the 5.
By the looks of that, you just need to enter 5 in each row.

You can enter 5, and drag the value down to duplicate.
Without any further information, and the spreadsheet to try and gather a better understanding of what you need.
I am unable to assist any further.