insert row when sum of values equals 100
Are there always blank cells below series of values, in your example cells
4,8,12?
Stefi
lloydyleg11 ezt *rta:
Hi,
I would like to insert a blank row when the sum of the values in a column of
cells equals 100.
Befo
1
2 10
3 90
4
5
6 50
7 50
8
9 10
10 10
11 80
12
After:
1
2 10
3 90
4
5
6 50
7 50
8
9 10
10 10
11 80
12
Hope this makes sense!
The values in the second column will always add to 100...
Thanks in advance!
|