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.

1
1
1
2
2
2
3
3
3
4
4
4 etc

<tbody>
</tbody>

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.