CODEWITHSUNDEEP
openoffice-calc
user3244842
user3244842

Reputation:

How to increase column values?

How to increase column values from:

1 | 1 | 7.317073
2 | 1 | 14.634146
3 | 1 | 24.390244
4 | 2 | 7.317073
5 | 2 | 14.634146
6 | 2 | 24.390244

To:

1 | 1 | 7.317073
2 | 1 | 14.634146
3 | 1 | 24.390244
4 | 2 | 7.317073
5 | 2 | 14.634146
6 | 2 | 24.390244
7 | 3 | 7.317073
8 | 3 | 14.634146
9 | 3 | 24.390244
10 | 4 | 7.317073
11 | 4 | 14.634146
12 | 4 | 24.390244

I'm using Open Office.

Upvotes: 0

Views: 170

Answers (2)

pnuts
pnuts

Reputation: 59495

For ColumnA simply selecting the first three rows, grabbing the fill handle (black square at the bottom right of the range) and dragging down to suit should be sufficient.

An alternative here to ROUNDUP is, in B1 and copied down:

=INT((ROW()-1)/3)+1

For ColumnC as for ColumnA but with Crl depressed.

Upvotes: 0

user1134316
user1134316

Reputation:

Assuming that the top left corner is A1, set the fourth row such:

A4: =A3+1

B4: =roundup(A4/3)

C4 =C1

And pull them up to row 12

Upvotes: 1

Related Questions