Sequencial number Issue 1.2.3. 1.2.3. 1.2.3. 1. 2. 3

[GerryZ]

Hello everybody
if you can help me i need a formula in A1 that gives sequencial number in this way
thank you!

Row\Col	A​
1​	1​
2​	2​
3​	3​
4​	1​
5​	2​
6​	3​
7​	1​
8​	2​
9​	3​
10​	1​
11​	2​
12​	3​

 

[gaz_chops]

Welcome to the forum, you need to add some explanation of what you want.

 

[Jonmo1]

Try this in A1 and filled down.

=MOD(ROWS($1:1)-1,3)+1

 

[GerryZ]

Welcome to the forum, you need to add some explanation of what you want.

yes in A1 I need a formula to copy down that gives me back sequelcial number 1.2.3.1.2.3.1.2.3.1.2.3.1.2.3
thank you!

 

[GerryZ]

Try this in A1 and filled down.

=MOD(ROWS($1:1)-1,3)+1

Thanks Jonmo1 works fine!!

 

[Jonmo1]

You're welcome.