I have a bunch of rows that yield results in the last column that in
many cases are blank or zero. I would like to be able to view the
results of only those cells that are non-blank, and show them on
another worksheet page. Copying the whole column would of course keep
the data spread out over lots of rown. Is there a way to somehow
remove the blanks? I've tried thinking about a VLOOKUP for non-blank
data, but that still is row by row.

Thanks for any help.

- Pete

data>filter>autofilter>>>

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
<petej@cadence.com> wrote in message
news:85f18b7b-5d6a-45dd-9370-6afac6c69738@a9g2000prl.googlegroups.com...
>I have a bunch of rows that yield results in the last column that in
> many cases are blank or zero. I would like to be able to view the
> results of only those cells that are non-blank, and show them on
> another worksheet page. Copying the whole column would of course keep
> the data spread out over lots of rown. Is there a way to somehow
> remove the blanks? I've tried thinking about a VLOOKUP for non-blank
> data, but that still is row by row.
>
> Thanks for any help.
>
> - Pete

Thanks. The problems with AutoFilter is it ends up sorting the whole
page. I would like to be able to group the results in a single column
on any page, without it affecting the other columns of that page. I'm
thinking that I may need to operate on this as an array somehow, does
that make sense?

- Pete

On May 1, 9:42*am, "Don Guillett" <dguille...@austin.rr.com> wrote:
> data>filter>autofilter>>>
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@austin.rr.com<pe...@cadence.com> wrote in message
>
> news:85f18b7b-5d6a-45dd-9370-6afac6c69738@a9g2000prl.googlegroups.com...
>
>
>
> >I have a bunch of rows that yield results in the last column that in
> > many cases are blank or zero. I would like to be able to view the
> > results of only those cells that are non-blank, and show them on
> > another worksheet page. Copying the whole column would of course keep
> > the data spread out over lots of rown. Is there a way to somehow
> > remove the blanks? I've tried thinking about a VLOOKUP for non-blank
> > data, but that still is row by row.
>
> > Thanks for any help.
>
> > - Pete- Hide quoted text -
>
> - Show quoted text -

You did say copy to another. Just copy the visible cells.

and show them on
> > another worksheet page. Copying the whole column would of course
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"petej" <peteandsue@comcast.net> wrote in message
news:44c0fba5-057c-4f41-bc5f-8f564d48ea50@l17g2000pri.googlegroups.com...
Thanks. The problems with AutoFilter is it ends up sorting the whole
page. I would like to be able to group the results in a single column
on any page, without it affecting the other columns of that page. I'm
thinking that I may need to operate on this as an array somehow, does
that make sense?

- Pete

On May 1, 9:42 am, "Don Guillett" <dguille...@austin.rr.com> wrote:
> data>filter>autofilter>>>
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@austin.rr.com<pe...@cadence.com> wrote in message
>
> news:85f18b7b-5d6a-45dd-9370-6afac6c69738@a9g2000prl.googlegroups.com...
>
>
>
> >I have a bunch of rows that yield results in the last column that in
> > many cases are blank or zero. I would like to be able to view the
> > results of only those cells that are non-blank, and show them on
> > another worksheet page. Copying the whole column would of course keep
> > the data spread out over lots of rown. Is there a way to somehow
> > remove the blanks? I've tried thinking about a VLOOKUP for non-blank
> > data, but that still is row by row.
>
> > Thanks for any help.
>
> > - Pete- Hide quoted text -
>
> - Show quoted text -

On Thu, 1 May 2008 15:09:19 -0700 (PDT), petej <peteandsue@comcast.net> wrote:

>Thanks. The problems with AutoFilter is it ends up sorting the whole
>page. I would like to be able to group the results in a single column
>on any page, without it affecting the other columns of that page. I'm
>thinking that I may need to operate on this as an array somehow, does
>that make sense?

Have you looked at "Lists" I have just read that and it may do what you want. I
have not used the feature yet
http://office.microsoft.com/training...RC010801391033
>
>- Pete
>
>On May 1, 9:42*am, "Don Guillett" <dguille...@austin.rr.com> wrote:
>> data>filter>autofilter>>>
>>
>> --
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> dguille...@austin.rr.com<pe...@cadence.com> wrote in message
>>
>> news:85f18b7b-5d6a-45dd-9370-6afac6c69738@a9g2000prl.googlegroups.com...
>>
>>
>>
>> >I have a bunch of rows that yield results in the last column that in
>> > many cases are blank or zero. I would like to be able to view the
>> > results of only those cells that are non-blank, and show them on
>> > another worksheet page. Copying the whole column would of course keep
>> > the data spread out over lots of rown. Is there a way to somehow
>> > remove the blanks? I've tried thinking about a VLOOKUP for non-blank
>> > data, but that still is row by row.
>>
>> > Thanks for any help.
>>
>> > - Pete- Hide quoted text -
>>
>> - Show quoted text -
--
Dave Mills
There are 10 type of people, those that understand binary and those that don't.