insert row when sum of values equals 100

L

lloydyleg11

Hi,

I would like to insert a blank row when the sum of the values in a column of
cells equals 100.

Before:
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!
 
S

Stefi

Are there always blank cells below series of values, in your example cells
4,8,12?
Stefi


„lloydyleg11†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top