Populate a Column
Populate a Column
(OP)
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
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





RE: Populate a Column
=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/
RE: Populate a Column
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Populate a Column
Dik
RE: Populate a Column
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".
RE: Populate a Column
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Populate a Column
Dik