Populate a Column 1

[dik]

I'm trying to create a column of sequential numbers up to a maximum defined number.

For example the maximum number is at C27 (say '8')

and I want
1 in B37
2
3
4
5
6
7
8

I've tried several variations of the following, in B38 to B68, without success...

=IF(AND(ISNUMBER(B37),B38<=$C$27),B37+1,"")

Does anyone have something that will do this?

Dik

 

[IDS]

Enter 1 in B38 Then:

=IF(AND(ISNUMBER(B38),B38<=$C$27-1),B38+1,"")

in B39 and copy that down

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[IDS]

Sorry, change all B38 to B37 and change B39 to B38.

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[dik]

Thanks...

Dik

 

[MintJulep]

Alternately, and much easier:

Enter your starting number in your desired starting cell.

Find "Fill | Series" in the menus. It's different places in different versions.

Enter the desired step value and stop value.

Click "ok".

 

[IDS]

Or enter the first two cells and then drag down as far as you want, but I assume he wants something that will update automatically when a new number is entered in C27.

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[dik]

Correct, IDS... and your suggested method works well... I'll take a gander at what the fill/series does...

Dik