Assigning serial numbers to non adjacent or non contiguous cells

[pbansl]

Is there any technique in Excel to assign serial numbers to non adjacent or non contiguous cells in Excel. For Example in cell A1 I want to assign 1, then after 2 rows in cell A4 I want to assign 2, then in A7 I want to assign 3, and so on with the rest cells in Column A ?

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff v2.xlsm
	A
1	1
2
3
4	2
5
6
7	3
8
9
10	4
11
12
13	5
Data

Cell Formulas
Range	Formula
A1:A13	A1	=IF(MOD(ROW()-1,3)=0,INT((ROW()-1)/3)+1,"")

 

[pbansl]

Hi & welcome to MrExcel.
How about

+Fluff v2.xlsm
	A
1	1
2
3
4	2
5
6
7	3
8
9
10	4
11
12
13	5
Data

Cell Formulas
Range	Formula
A1:A13	A1	=IF(MOD(ROW()-1,3)=0,INT((ROW()-1)/3)+1,"")

Thank you very much. It worked.

 

[Fluff]

You're welcome & thanks for the feedback.