I am trying to average some data in my excel spreadsheet basically it looks like:
<colgroup><col><col></colgroup><tbody>
</tbody>
I need to average the first set of 2-4 and then the second set and so on and so forth and I am looking for an easy way to do that without Manually going through each cell.
I am sort of familiar with VBA but not enough to create my own code if that is what is needed.
Thanks.
1 | 5 |
2 | 6 |
3 | 5 |
4 | 6 |
1 | 5 |
2 | 6 |
3 | 5 |
4 | 6 |
<colgroup><col><col></colgroup><tbody>
</tbody>
I need to average the first set of 2-4 and then the second set and so on and so forth and I am looking for an easy way to do that without Manually going through each cell.
I am sort of familiar with VBA but not enough to create my own code if that is what is needed.
Thanks.