I have several columns of data. For instance:
Col B Col C Col D Col E Col F Col G
Row 1 250 125 89
Row 2 125 217 144
Row 3 166 144 105
Row 4 122 110
Row 5 155
Row 6

What I need is to be able to copy the last item in Col B (166 in Row 3) into
C1 and the last item from Column D (155 in Row 5) into E1 etc. I have three
colums I need to do this to. The number of the filled cells in the colums
could be anywhere from 1 to 6. Any suggestions on how to do this would be
appreciated.

Jonco

Jonco,

Select the cell in B3, and edge-drag it, holding Shift, above C1. This will
move the stuff in C down. If you don't want that, don't use Shift.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"jonco" <(E-Mail Removed)> wrote in message
news:4IG_d.11262$(E-Mail Removed)...
>I have several columns of data. For instance:
> Col B Col C Col D Col E Col F Col G
> Row 1 250 125 89
> Row 2 125 217 144
> Row 3 166 144 105
> Row 4 122 110
> Row 5 155
> Row 6
>
> What I need is to be able to copy the last item in Col B (166 in Row 3)
> into C1 and the last item from Column D (155 in Row 5) into E1 etc. I
> have three colums I need to do this to. The number of the filled cells in
> the colums could be anywhere from 1 to 6. Any suggestions on how to do
> this would be appreciated.
>
> Jonco
>

What I meant was to do this automatically using a formula or VBA if
necessasy. I know how to copy & paste. Thanks anyway Earl.

Jonco


On Fri, 18 Mar 2005 16:23:59 -0500, "Earl Kiosterud"
<(E-Mail Removed)> wrote:

>Jonco,
>
>Select the cell in B3, and edge-drag it, holding Shift, above C1. This will
>move the stuff in C down. If you don't want that, don't use Shift.

Jonco

If always numeric data in B, D, F

In C1 enter =LOOKUP(9.99999999999999E+307,B:B)

In E1 enter =LOOKUP(9.99999999999999E+307,D)

If not numeric use =LOOKUP(REPT("z",255),B:B)


Gord Dibben Excel MVP

On Fri, 18 Mar 2005 23:49:10 GMT, Jonco <(E-Mail Removed)> wrote:

>What I meant was to do this automatically using a formula or VBA if
>necessasy. I know how to copy & paste. Thanks anyway Earl.
>
>Jonco
>
>
>On Fri, 18 Mar 2005 16:23:59 -0500, "Earl Kiosterud"
><(E-Mail Removed)> wrote:
>
>>Jonco,
>>
>>Select the cell in B3, and edge-drag it, holding Shift, above C1. This will
>>move the stuff in C down. If you don't want that, don't use Shift.

Gord -

Would you be kind enough to explain how in the heck that works. I'm not
smart enough to understand what it's doing.

Thanks
Duke


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:(E-Mail Removed)...
> Jonco
>
> If always numeric data in B, D, F
>
> In C1 enter =LOOKUP(9.99999999999999E+307,B:B)
>
> In E1 enter =LOOKUP(9.99999999999999E+307,D)
>
> If not numeric use =LOOKUP(REPT("z",255),B:B)
>
>
> Gord Dibben Excel MVP
>
> On Fri, 18 Mar 2005 23:49:10 GMT, Jonco <(E-Mail Removed)> wrote:
>
>>What I meant was to do this automatically using a formula or VBA if
>>necessasy. I know how to copy & paste. Thanks anyway Earl.
>>
>>Jonco
>>
>>
>>On Fri, 18 Mar 2005 16:23:59 -0500, "Earl Kiosterud"
>><(E-Mail Removed)> wrote:
>>
>>>Jonco,
>>>
>>>Select the cell in B3, and edge-drag it, holding Shift, above C1. This
>>>will
>>>move the stuff in C down. If you don't want that, don't use Shift.
>

Hi Duke

check out
http://www.xldynamic.com/source/xld.LastValue.html

for the first two formulas read sections -

#002 - Searching For Largest Possible Number Using LOOKUP
(and you'll probably have to read #001 as well)

for the last formula check out
#006 - Searching For Largest Possible Number Using LOOKUP
(and have a read of #005 as well)

Cheers
JulieD


"Duke Carey" <duke_No_Junk_carey_at_hotmail.com> wrote in message
news:(E-Mail Removed)...
> Gord -
>
> Would you be kind enough to explain how in the heck that works. I'm not
> smart enough to understand what it's doing.
>
> Thanks
> Duke
>
>
> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> news:(E-Mail Removed)...
>> Jonco
>>
>> If always numeric data in B, D, F
>>
>> In C1 enter =LOOKUP(9.99999999999999E+307,B:B)
>>
>> In E1 enter =LOOKUP(9.99999999999999E+307,D)
>>
>> If not numeric use =LOOKUP(REPT("z",255),B:B)
>>
>>
>> Gord Dibben Excel MVP
>>
>> On Fri, 18 Mar 2005 23:49:10 GMT, Jonco <(E-Mail Removed)> wrote:
>>
>>>What I meant was to do this automatically using a formula or VBA if
>>>necessasy. I know how to copy & paste. Thanks anyway Earl.
>>>
>>>Jonco
>>>
>>>
>>>On Fri, 18 Mar 2005 16:23:59 -0500, "Earl Kiosterud"
>>><(E-Mail Removed)> wrote:
>>>
>>>>Jonco,
>>>>
>>>>Select the cell in B3, and edge-drag it, holding Shift, above C1. This
>>>>will
>>>>move the stuff in C down. If you don't want that, don't use Shift.
>>
>
>

Thanks Julie

Hope this helps you Duke.

I can't say it any better(or even near as well)than Frank and Bob have done.


Gord


On Sun, 20 Mar 2005 23:25:45 +0800, "JulieD" <(E-Mail Removed)>
wrote:

>Hi Duke
>
>check out
>http://www.xldynamic.com/source/xld.LastValue.html
>
>for the first two formulas read sections -
>
>#002 - Searching For Largest Possible Number Using LOOKUP
>(and you'll probably have to read #001 as well)
>
>for the last formula check out
>#006 - Searching For Largest Possible Number Using LOOKUP
>(and have a read of #005 as well)
>
>Cheers
>JulieD
>
>
>"Duke Carey" <duke_No_Junk_carey_at_hotmail.com> wrote in message
>news:(E-Mail Removed)...
>> Gord -
>>
>> Would you be kind enough to explain how in the heck that works. I'm not
>> smart enough to understand what it's doing.
>>
>> Thanks
>> Duke
>>
>>
>> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
>> news:(E-Mail Removed)...
>>> Jonco
>>>
>>> If always numeric data in B, D, F
>>>
>>> In C1 enter =LOOKUP(9.99999999999999E+307,B:B)
>>>
>>> In E1 enter =LOOKUP(9.99999999999999E+307,D)
>>>
>>> If not numeric use =LOOKUP(REPT("z",255),B:B)
>>>
>>>
>>> Gord Dibben Excel MVP
>>>
>>> On Fri, 18 Mar 2005 23:49:10 GMT, Jonco <(E-Mail Removed)> wrote:
>>>
>>>>What I meant was to do this automatically using a formula or VBA if
>>>>necessasy. I know how to copy & paste. Thanks anyway Earl.
>>>>
>>>>Jonco
>>>>
>>>>
>>>>On Fri, 18 Mar 2005 16:23:59 -0500, "Earl Kiosterud"
>>>><(E-Mail Removed)> wrote:
>>>>
>>>>>Jonco,
>>>>>
>>>>>Select the cell in B3, and edge-drag it, holding Shift, above C1. This
>>>>>will
>>>>>move the stuff in C down. If you don't want that, don't use Shift.
>>>
>>
>>
>

Thanks for the help guys (and gals). I will check it out. I appreciate the
help.
Jonco
"jonco" <(E-Mail Removed)> wrote in message
news:4IG_d.11262$(E-Mail Removed)...
>I have several columns of data. For instance:
> Col B Col C Col D Col E Col F Col G
> Row 1 250 125 89
> Row 2 125 217 144
> Row 3 166 144 105
> Row 4 122 110
> Row 5 155
> Row 6
>
> What I need is to be able to copy the last item in Col B (166 in Row 3)
> into C1 and the last item from Column D (155 in Row 5) into E1 etc. I
> have three colums I need to do this to. The number of the filled cells in
> the colums could be anywhere from 1 to 6. Any suggestions on how to do
> this would be appreciated.
>
> Jonco
>