counter through a list.

[redahussien]

hi , how to loop through this list and make a counter when reach the first group of 10's return 1 , and when reach the second group of 10's return 2 ,
for the third group it will return 3 and so on.
1
2
3
7
8
10
10
1
2
5
6
7
10
10
10
2
3
4
8
9
10
5
6
9

[TMS]

Assuming the data starts in column A, row 2, then in cell B2:

Please Login or Register  to view this content.

and copy down.