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)
<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.
<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 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)
<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.