Formula to perform number from 1 based on numbers in column A

[bjnockle]

Looking for formula to look through column A and then number the numbers in column A from lowest to largest (largest is the number in column A).

Example: If A2=6
Formula outcome (B2:G2) =1 2 3 4 5 6

Example: If A3=12
Formula outcome (B3:M3) =1 2 3 4 5 6 7 8 9 10 11 12

Example: If A3=18
Formula outcome (B4:S4) =1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

Please Login or Register  to view this content.

[Fluff13]

How about, in B2 copied down & across
=IF(COLUMNS($B1:B1)>$A2,"",COLUMNS($B1:B1))

[CARACALLA]

B2=if(columns($b2:b2)<=$a2,columns($b2:b2),"")

Copy across and down

[bjnockle]

Fluff13: Excellent solution. Thanks a lot.

[bjnockle]

CARACALLA : Outstanding solution. Thanks a lot.

[Fluff13]

You're welcome & thanks for the feedback.

[CARACALLA]

You are welcome