Extend series

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Traci - 15 Jun 2006 05:58 GMT

I am needing to find a way to 'extend a series' for an entire column with
multiple numbers without having to extend each series individually.

Here's basically what I have: Here's what I need it to look like:

345 345
(blank cell) 345
(blank cell) 345
(blank cell) 345
675 675
(blank cell) 675
(blank cell) 675
987 987
(blank cell) 987
(blank cell) 987
(blank cell) 987

Right now I'm have to click each number to get it to extend the series down
to the next number. Typically this wouldn't be a big hassel to do them
individually, but I'm now dealing with over 1,400 numbers and doing this
individually all the way down the column is very time consuming and making me
crazy! Does anyone have any suggestions? Thank you for any input!

Reply to this Message

Biff - 15 Jun 2006 06:19 GMT

Hi!

You could use a helper column:

Assume your first number is in A1:

A1 = 345

In B1 enter 345

In B2 enter this formula and copy down as needed:

=IF(A2="",B1,A2)

Biff

>I am needing to find a way to 'extend a series' for an entire column with
> multiple numbers without having to extend each series individually.
[quoted text clipped - 21 lines]
> me
> crazy! Does anyone have any suggestions? Thank you for any input!

Reply to this Message

Traci - 16 Jun 2006 07:10 GMT

Thank you so much for the suggestion...the only problem I've run into with
trying your formula is that I then have two seperate columns with the numbers
(as in your example, I would have individual numbers in column A and the
filled series in column B.) I've having to import this data into Microsoft
Acess, and so it has to be formatted where all the numbers are filled in the
one row instead of two. I tried to taking the individual column, A, and just
deleting it since column B had the filled series I need, but then all the
info in column B erases because column A is gone. Do you have any
suggestions for how I might do exactly what you said before, only get it down
to one column?
Thank you sooooooooo much!!!

> Hi!
>
[quoted text clipped - 37 lines]
> > me
> > crazy! Does anyone have any suggestions? Thank you for any input!

Reply to this Message

Biff - 16 Jun 2006 19:38 GMT

Put the formulas in column B.

Now, select column B.
Goto Edit>Copy
Then Edit>Paste Special>Values>OK

This will convert the formulas to constants then you can delete column A.

Biff

> Thank you so much for the suggestion...the only problem I've run into with
> trying your formula is that I then have two seperate columns with the
[quoted text clipped - 57 lines]
>> > me
>> > crazy! Does anyone have any suggestions? Thank you for any input!

Reply to this Message

Traci - 17 Jun 2006 00:16 GMT

Thank you!!!!!!! you just saved me sooo much time, you're awsome! :)

> Put the formulas in column B.
>
[quoted text clipped - 67 lines]
> >> > me
> >> > crazy! Does anyone have any suggestions? Thank you for any input!

Reply to this Message

Biff - 17 Jun 2006 03:32 GMT

You're welcome. Thanks for the feedback!

Biff

> Thank you!!!!!!! you just saved me sooo much time, you're awsome! :)
>
[quoted text clipped - 78 lines]
>> >> > me
>> >> > crazy! Does anyone have any suggestions? Thank you for any input!

Reply to this Message