Finding Count of Groups of Data in a Row

[wmunsey81]

Hello all my Excel Gurus!

I want to count the number of segments, or groups of data, in this array. The results should be 3. (I think I might have to add zeros in the blanks)

20 85 65 65 20 22 <tbody> </tbody>

<tbody>
</tbody>

Then add one more step into this.
If I had 20 in stock. How many segments are greater than 20. The answer would be 2.

20

85

65

65

20

22

<tbody>
</tbody>

The groups would be events as each column is basically a day of use of an item. I have a feeling that the second answer is a nesting of the first answer. If anyone could help or needs more info (it took me a little bit to understand the question as well), let me know.

 

[wmunsey81]

Hello all my Excel Gurus!

I want to count the number of segments, or groups of data, in this array. The results should be 3. (I think I might have to add zeros in the blanks)

20 85 65 65 20 22 <tbody> </tbody>

<tbody>
</tbody>

Then add one more step into this.
If I had 20 in stock. How many segments are greater than 20. The answer would be 2.

20

85

65

65

20

22

<tbody>
</tbody>

The groups would be events as each column is basically a day of use of an item. I have a feeling that the second answer is a nesting of the first answer. If anyone could help or needs more info (it took me a little bit to understand the question as well), let me know.

I am sorry, the "array" terminology may be a bit confusing as this would be something in a VBA code. This is actually data in cells in a table.

Hopefully that helps a little more in finding the answer I was looking for.