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)

[TABLE="width: 907"]
<tbody>[TR]
[TD][TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]20[/TD]
[TD][/TD]
[TD="align: center"]85[/TD]
[TD="align: center"]65[/TD]
[TD="align: center"]65[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]22[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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.

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]20[/TD]
[TD][/TD]
[TD="align: center"]85[/TD]
[TD="align: center"]65[/TD]
[TD="align: center"]65[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]22[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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)

[TABLE="width: 907"]
<tbody>[TR]
[TD][TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]20[/TD]
[TD][/TD]
[TD="align: center"]85[/TD]
[TD="align: center"]65[/TD]
[TD="align: center"]65[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]22[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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.

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]20[/TD]
[TD][/TD]
[TD="align: center"]85[/TD]
[TD="align: center"]65[/TD]
[TD="align: center"]65[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]22[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.