Auto trend series

[tahirawan11]

Hi,

I want to create a auto trend series which can be generated as fallows

1
1
1
1
1
2
2
2
2
2
3
3
3
3
3
4
4
4
4
4
5
5
5
5
5
.
.
.
.
.

Can anyone help me how can i create this list????

[shg]

Starting in A6 and copy down:

=A1+1

[tahirawan11]

Hi shg

u saved lot of my time !!!!