name list

[Pong]

Hi,

I have a database and we would like to do some sorting. My data may looks
like below

Ron 1 3
Jes 2 7
Dan 3
Raj 4 5
Ali 5
Lily 6 2

I have data in column A, B & C. I would like to do a sorting to show the
name on other worksheet HORIZONTALLY if both column B & C are bigger than 0.
The result should like this

Ron Jes Raj Lily

Any idea?

[Backdoor Cover]

If you want to do it manually I suggest sorting by column B and then copy paste the list of names and then where you want them horizontal, you would right click PASTE SPECIAL. Select Transpose.

No one likes manual work but it takes seconds to do.

[Don Guillett]

See my ans to your later post

--
Don Guillett
SalesAid Software
[email protected]
"Backdoor Cover"
<[email protected]> wrote in
message news:[email protected]...
>
> If you want to do it manually I suggest sorting by column B and then
> copy paste the list of names and then where you want them horizontal,
> you would right click PASTE SPECIAL. Select Transpose.
>
> No one likes manual work but it takes seconds to do.
>
>
> --
> Backdoor Cover
> ------------------------------------------------------------------------
> Backdoor Cover's Profile:
http://www.excelforum.com/member.php...o&userid=19842
> View this thread: http://www.excelforum.com/showthread...hreadid=376068
>

[Pong]

Manually does not work for us. We have a database with 250 entries and
column A are names of customers. Column B,C,D and E are greater than zero if
they belong to that particular route (B,C,D,E each representing a driver)and
column F is if they are taking particular items. Therefore, we want to
summarize on a seperate sheets the names of customers that belong to that
route and taking that particular item.

Example:

A B C D E F
safeway 2
albertson 3 1
cooper 4 1
ov 5 1
iga 6
7-11 7 1
max 8 1
chevron 9
esso 10


FINAL RESULT

driver B max
driver C albertson 7-11
driver D cooper
driver E ov

I hope I was not too confusing.

Thanks

"Backdoor Cover" wrote:

>
> If you want to do it manually I suggest sorting by column B and then
> copy paste the list of names and then where you want them horizontal,
> you would right click PASTE SPECIAL. Select Transpose.
>
> No one likes manual work but it takes seconds to do.
>
>
> --
> Backdoor Cover
> ------------------------------------------------------------------------
> Backdoor Cover's Profile: http://www.excelforum.com/member.php...o&userid=19842
> View this thread: http://www.excelforum.com/showthread...hreadid=376068
>
>

[Pong]

Manually won't work because we have approx 250 items and we need to summarize
it by
by 4 different routes.

For example in column A we have customers and column B-E are the four routes
and
column F will be greater than zero idf they are taking particular item.
We want to summarize horizontally the customers who have a value greater
than zero
in column F, by each driver.
So our net result will be a list for each driver that will contain only the
customers on his
route that have a value gretaer than zero in column F

Example:

A B C D E F
safeway 2
albertson 3 1
cooper 4 1
ov 5 1
iga 6
7-11 7 1
max 8 1
chevron 9
esso 10


FINAL RESULT

driver B max
driver C albertson 7-11
driver D cooper
driver E ov


"Don Guillett" wrote:

> See my ans to your later post
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "Backdoor Cover"
> <[email protected]> wrote in
> message news:[email protected]...
> >
> > If you want to do it manually I suggest sorting by column B and then
> > copy paste the list of names and then where you want them horizontal,
> > you would right click PASTE SPECIAL. Select Transpose.
> >
> > No one likes manual work but it takes seconds to do.
> >
> >
> > --
> > Backdoor Cover
> > ------------------------------------------------------------------------
> > Backdoor Cover's Profile:
> http://www.excelforum.com/member.php...o&userid=19842
> > View this thread: http://www.excelforum.com/showthread...hreadid=376068
> >
>
>
>

[Don Guillett]

My response did not involve doing it manually. Did you see my answer in your
later post?

--
Don Guillett
SalesAid Software
[email protected]
"Pong" <[email protected]> wrote in message
news:[email protected]...
> Manually won't work because we have approx 250 items and we need to
summarize
> it by
> by 4 different routes.
>
> For example in column A we have customers and column B-E are the four
routes
> and
> column F will be greater than zero idf they are taking particular item.
> We want to summarize horizontally the customers who have a value greater
> than zero
> in column F, by each driver.
> So our net result will be a list for each driver that will contain only
the
> customers on his
> route that have a value gretaer than zero in column F
>
> Example:
>
> A B C D E F
> safeway 2
> albertson 3 1
> cooper 4 1
> ov 5 1
> iga 6
> 7-11 7 1
> max 8 1
> chevron 9
> esso 10
>
>
> FINAL RESULT
>
> driver B max
> driver C albertson 7-11
> driver D cooper
> driver E ov
>
>
> "Don Guillett" wrote:
>
> > See my ans to your later post
> >
> > --
> > Don Guillett
> > SalesAid Software
> > [email protected]
> > "Backdoor Cover"
> > <[email protected]> wrote in
> > message
news:[email protected]...
> > >
> > > If you want to do it manually I suggest sorting by column B and then
> > > copy paste the list of names and then where you want them horizontal,
> > > you would right click PASTE SPECIAL. Select Transpose.
> > >
> > > No one likes manual work but it takes seconds to do.
> > >
> > >
> > > --
> > > Backdoor Cover
> >
> ------------------------------------------------------------------------
> > > Backdoor Cover's Profile:
> > http://www.excelforum.com/member.php...o&userid=19842
> > > View this thread:
http://www.excelforum.com/showthread...hreadid=376068
> > >
> >
> >
> >