Arranging some numbers as per specification

[baidya91]

How to arrange some numbers in excel through formula or trick:

1 2 3 4
8 7 6 5
9 10 11 12
16 15 14 13

 

[Eric W]

Try:

Book1
	A	B	C	D	E
1
2		1	2	3	4
3		8	7	6	5
4		9	10	11	12
5		16	15	14	13
Sheet2

Cell Formulas
Range	Formula
B2:E5	B2	=IF(COLUMN()=2,IF(MOD(ROW(),2)=0,B1+1,MAX(1:1)+COUNT(1:1)),IF(MOD(ROW(),2),A2-1,A2+1))

Put the formula in B2 and copy down and across as needed. I started in B2 instead of A1, since it was easier, but that can be changed. Also, this assumes you don't have anything else on the sheet. We can also adjust that by limiting the ranges.

Hope this helps.