Could anyone help me with a vba script that calculated the proportion of each row for every 4four rows. (e.g. 1/sum(1+0+3+3) 0/sum(1+0+3+3)).
It is to be calculated from row L2:L753 and is to be displayed in row K2:K753
L K
Count Allocation
1 0.14
0 0.00
3 0.43
3 0.43
0 0.00
5 0.71
2 0.29
0 0.00
0
3
4
4
1
2
0
0
1
6
2
1
0
5
4
7
1
5
3
8
Nic