formula that adds a number for every consectutive 3 cells at a time?

[tjdesign]

Hi, I'm having some trouble trying to make something that will add a number for every 3 cells down a column.

It would look something like this, but would continue for about 93000 cells so I really need a formula to do this.
[TABLE="width: 107"]
<tbody>[TR]
[TD="align: right"]

1
[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]1
[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]4
etc

[/TD]
[/TR]
</tbody>[/TABLE]
Any help would be really appreciated, thank you

 

[Aladin Akyurek]

What is the expected result for the sample you posted?

 

[gaz_chops]

Welcome to the forum.

Try
In 1st cell enter 1
in next cell enter
=INT(ROW(A1)/3)+1

 

[tjdesign]

That's it! Fantastic! Thank you very much

 

[gaz_chops]

You're welcome, thanks for the feedback.