Hi,
I'm sure this has been asked before in some way but I wasn't sure how to search it...
I have a column of data which has intermittent non zero values. I would like to average the groups of non zero values and need a dynamic formula for this as the rows of data are many. here is an example of the data:
<tbody>
</tbody>
I would like to average the first 6,5,4 and then the next 6,5,4,3 in a second column. I have 20k rows of data in reality and there is no pattern to how many rows appear in a grouping.
Thanks for any help.
I'm sure this has been asked before in some way but I wasn't sure how to search it...
I have a column of data which has intermittent non zero values. I would like to average the groups of non zero values and need a dynamic formula for this as the rows of data are many. here is an example of the data:
0 |
6 |
5 |
4 |
0 |
0 |
6 |
5 |
4 |
3 |
<tbody>
</tbody>
I would like to average the first 6,5,4 and then the next 6,5,4,3 in a second column. I have 20k rows of data in reality and there is no pattern to how many rows appear in a grouping.
Thanks for any help.