PC Review


Reply
Thread Tools Rate Thread

Breakdown grouping

 
 
red_jellybean
Guest
Posts: n/a
 
      9th Jul 2008
I need to breakdown the spreadsheet.
Origin City, Origin State, Dest City, Dest ST, Product Code = Freight Rate.

Somehow, the data provided to me is
Origin Group, Dest Group, Product code group = Freight Rate

and then a seperate spreadsheet with the cities in the Origin Group or
cities in the Dest Group and also Product Codes in the grouping.

I would like to know if there is a way to split the grouping up and make it
show specific Origin, Dest, Product Code.

Origin Dest Product Code
Rate
Houston Group Midland Group 28181 $1000

Houston Group
Houston
Deer Park
Dallas

Midland Group
Midland
Bay City
Saginaw

28181 Group
2818101
2818102
2818103

So any combination of the 3 groups will have the same frieght rate of $1000
 
Reply With Quote
 
 
 
 
Charlie
Guest
Posts: n/a
 
      9th Jul 2008
I can't help but notice the data. Look's like you could be down the hall
from me. Dial x2158, if I answer the phone I can help you with your
workbook. If someone else answers don't tell 'em who sent you!

"red_jellybean" wrote:

> I need to breakdown the spreadsheet.
> Origin City, Origin State, Dest City, Dest ST, Product Code = Freight Rate.
>
> Somehow, the data provided to me is
> Origin Group, Dest Group, Product code group = Freight Rate
>
> and then a seperate spreadsheet with the cities in the Origin Group or
> cities in the Dest Group and also Product Codes in the grouping.
>
> I would like to know if there is a way to split the grouping up and make it
> show specific Origin, Dest, Product Code.
>
> Origin Dest Product Code
> Rate
> Houston Group Midland Group 28181 $1000
>
> Houston Group
> Houston
> Deer Park
> Dallas
>
> Midland Group
> Midland
> Bay City
> Saginaw
>
> 28181 Group
> 2818101
> 2818102
> 2818103
>
> So any combination of the 3 groups will have the same frieght rate of $1000

 
Reply With Quote
 
red_jellybean
Guest
Posts: n/a
 
      9th Jul 2008
How do you know if I'm down the hall from you? I don't recall populating any
personal data. Where r u located?

"Charlie" wrote:

> I can't help but notice the data. Look's like you could be down the hall
> from me. Dial x2158, if I answer the phone I can help you with your
> workbook. If someone else answers don't tell 'em who sent you!
>
> "red_jellybean" wrote:
>
> > I need to breakdown the spreadsheet.
> > Origin City, Origin State, Dest City, Dest ST, Product Code = Freight Rate.
> >
> > Somehow, the data provided to me is
> > Origin Group, Dest Group, Product code group = Freight Rate
> >
> > and then a seperate spreadsheet with the cities in the Origin Group or
> > cities in the Dest Group and also Product Codes in the grouping.
> >
> > I would like to know if there is a way to split the grouping up and make it
> > show specific Origin, Dest, Product Code.
> >
> > Origin Dest Product Code
> > Rate
> > Houston Group Midland Group 28181 $1000
> >
> > Houston Group
> > Houston
> > Deer Park
> > Dallas
> >
> > Midland Group
> > Midland
> > Bay City
> > Saginaw
> >
> > 28181 Group
> > 2818101
> > 2818102
> > 2818103
> >
> > So any combination of the 3 groups will have the same frieght rate of $1000

 
Reply With Quote
 
Charlie
Guest
Posts: n/a
 
      9th Jul 2008
No, not personal data. We have offices in some of these places (I'm in
Houston) and I thought you might be up in the purchasing group (judging by
Freight Rate). But, it was just a wild guess.

Your workbook problem would be easier to solve by someone who could look at
the whole package, and I was willing to do that if we were in the same
office, but it's a little more complex than I usually try to answer here.
Someone may try. You may need to provide more details though.

Regards,
Charlie

"red_jellybean" wrote:

> How do you know if I'm down the hall from you? I don't recall populating any
> personal data. Where r u located?
>
> "Charlie" wrote:
>
> > I can't help but notice the data. Look's like you could be down the hall
> > from me. Dial x2158, if I answer the phone I can help you with your
> > workbook. If someone else answers don't tell 'em who sent you!
> >
> > "red_jellybean" wrote:
> >
> > > I need to breakdown the spreadsheet.
> > > Origin City, Origin State, Dest City, Dest ST, Product Code = Freight Rate.
> > >
> > > Somehow, the data provided to me is
> > > Origin Group, Dest Group, Product code group = Freight Rate
> > >
> > > and then a seperate spreadsheet with the cities in the Origin Group or
> > > cities in the Dest Group and also Product Codes in the grouping.
> > >
> > > I would like to know if there is a way to split the grouping up and make it
> > > show specific Origin, Dest, Product Code.
> > >
> > > Origin Dest Product Code
> > > Rate
> > > Houston Group Midland Group 28181 $1000
> > >
> > > Houston Group
> > > Houston
> > > Deer Park
> > > Dallas
> > >
> > > Midland Group
> > > Midland
> > > Bay City
> > > Saginaw
> > >
> > > 28181 Group
> > > 2818101
> > > 2818102
> > > 2818103
> > >
> > > So any combination of the 3 groups will have the same frieght rate of $1000

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
best breakdown ekkeindoha Microsoft Excel Worksheet Functions 2 3rd Feb 2010 06:45 PM
Task Bar Grouping not working, box is checked, 11 windows, no grouping...HELP! TIA ABDJCJ Windows Vista General Discussion 0 31st Aug 2007 06:50 AM
Breakdown =?Utf-8?B?QUo=?= Microsoft Excel Worksheet Functions 1 3rd May 2006 09:02 PM
SP 2 breakdown Zack Griendling Windows XP Configuration 8 20th May 2005 08:20 PM
Serious breakdown...... scotty Windows XP Accessibility 2 6th Mar 2004 10:12 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:08 PM.