1

I have this spreadsheet in the picture... I want to fill up to 30/ago but the only way I know is to fill by hand...

What would be the formula to drag this horizontally and it increment by 1 per column?

nightshade
  • 638
  • 5
  • 15

1 Answers1

2

You can use:

=COLUMN() & "/ago"

it returns 1/ago in first column, 2/ago is second and so on.

Also you can adjust formula, say:

=(COLUMN() -3) & "/ago"

returns 1/ago in column 4, 2/ago in column 5 and so on.

enter image description here

Another way: in starting cell, say B4 wirte 1/ago. Then in next cell, C4 in our case, write 

=COUNTA($B$4:B$4)+1 & "/ago"

and drag across

enter image description here

Dmitry Pavliv
  • 35,333
  • 13
  • 79
  • 80