Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breakdown grouping
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breakdown grouping
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breakdown grouping
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breakdown grouping
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
best breakdown | Excel Worksheet Functions | |||
Monthly Breakdown | Excel Worksheet Functions | |||
Breakdown | Excel Worksheet Functions | |||
How 2 breakdown $$$ into $ $ $? | Excel Discussion (Misc queries) | |||
Numerical Breakdown | Excel Programming |