×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Populate a Column

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

RE: Populate a Column

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/

RE: Populate a Column

(OP)
Thanks...

Dik

RE: Populate a Column

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".

RE: Populate a Column

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/

RE: Populate a Column

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

Dik

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources