Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto grouping.
In column B I have our part numbers and in column A is our serial numbers.
Is there a way I can group the serial numbers with the correspondingpart number with out doing this manually. Not every product number has serial numbers and the products that do may have only one serial number or many serial numbers depending on the quantities. Serial # Product # 104-214100 4243232 4334532 104-214101 104-214103 5342322 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto grouping.
Hi, Use pivot table, very easy. Use the wizard. Mathew
"bduncan" wrote in message ... In column B I have our part numbers and in column A is our serial numbers. Is there a way I can group the serial numbers with the correspondingpart number with out doing this manually. Not every product number has serial numbers and the products that do may have only one serial number or many serial numbers depending on the quantities. Serial # Product # 104-214100 4243232 4334532 104-214101 104-214103 5342322 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto grouping.
thanks for the reply. How would you organize a pivot table to do this. My
serial numbers are listed in column A starting on the row below where the part numbers are listed in column b. I'm not sure how pivot tables would do this. My example below my message is how the information gets imported into excel from our accounting software. "Mathew P Bennett" wrote: Hi, Use pivot table, very easy. Use the wizard. Mathew "bduncan" wrote in message ... In column B I have our part numbers and in column A is our serial numbers. Is there a way I can group the serial numbers with the correspondingpart number with out doing this manually. Not every product number has serial numbers and the products that do may have only one serial number or many serial numbers depending on the quantities. Serial # Product # 104-214100 4243232 4334532 104-214101 104-214103 5342322 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto grouping.
Hi There, so am I correct in assuming that every Serial row is blank when
Product is filled, & vice-vera? If so I would ensure that this is not just a row enrty error (from your accounts package into xl, of either Serial or Produst, and firstly to determine to which Serial does Product 104-21400 belong? I know about exporting data from accounting packages into excel, better to go via the MSQuery route of the a/c package database, eg ACCDATA in SageLine50 Hope this helps. Mathew "bduncan" wrote in message ... thanks for the reply. How would you organize a pivot table to do this. My serial numbers are listed in column A starting on the row below where the part numbers are listed in column b. I'm not sure how pivot tables would do this. My example below my message is how the information gets imported into excel from our accounting software. "Mathew P Bennett" wrote: Hi, Use pivot table, very easy. Use the wizard. Mathew "bduncan" wrote in message ... In column B I have our part numbers and in column A is our serial numbers. Is there a way I can group the serial numbers with the correspondingpart number with out doing this manually. Not every product number has serial numbers and the products that do may have only one serial number or many serial numbers depending on the quantities. Serial # Product # 104-214100 4243232 4334532 104-214101 104-214103 5342322 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto grouping.
Yes you are correct. I don't believe this is a row entry error from the
software. This is just how it exports it. Product Id is in column b and the part numbers that have serial numbers will have them listed in column A on the next rows below the product Id in column B. I just would like to automatically have the product Id and serial numbers grouped together. "Mathew P Bennett" wrote: Hi There, so am I correct in assuming that every Serial row is blank when Product is filled, & vice-vera? If so I would ensure that this is not just a row enrty error (from your accounts package into xl, of either Serial or Produst, and firstly to determine to which Serial does Product 104-21400 belong? I know about exporting data from accounting packages into excel, better to go via the MSQuery route of the a/c package database, eg ACCDATA in SageLine50 Hope this helps. Mathew "bduncan" wrote in message ... thanks for the reply. How would you organize a pivot table to do this. My serial numbers are listed in column A starting on the row below where the part numbers are listed in column b. I'm not sure how pivot tables would do this. My example below my message is how the information gets imported into excel from our accounting software. "Mathew P Bennett" wrote: Hi, Use pivot table, very easy. Use the wizard. Mathew "bduncan" wrote in message ... In column B I have our part numbers and in column A is our serial numbers. Is there a way I can group the serial numbers with the correspondingpart number with out doing this manually. Not every product number has serial numbers and the products that do may have only one serial number or many serial numbers depending on the quantities. Serial # Product # 104-214100 4243232 4334532 104-214101 104-214103 5342322 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto grouping.
Hi there, which is the higher category, Serial or Product? If yo do not get
any other help, email me some of anonomysed data as xls. it may be as simple as using the INDIRECT fn. I would post again (in a new thread) with more dtail of your ss. M. "bduncan" wrote in message ... Yes you are correct. I don't believe this is a row entry error from the software. This is just how it exports it. Product Id is in column b and the part numbers that have serial numbers will have them listed in column A on the next rows below the product Id in column B. I just would like to automatically have the product Id and serial numbers grouped together. "Mathew P Bennett" wrote: Hi There, so am I correct in assuming that every Serial row is blank when Product is filled, & vice-vera? If so I would ensure that this is not just a row enrty error (from your accounts package into xl, of either Serial or Produst, and firstly to determine to which Serial does Product 104-21400 belong? I know about exporting data from accounting packages into excel, better to go via the MSQuery route of the a/c package database, eg ACCDATA in SageLine50 Hope this helps. Mathew "bduncan" wrote in message ... thanks for the reply. How would you organize a pivot table to do this. My serial numbers are listed in column A starting on the row below where the part numbers are listed in column b. I'm not sure how pivot tables would do this. My example below my message is how the information gets imported into excel from our accounting software. "Mathew P Bennett" wrote: Hi, Use pivot table, very easy. Use the wizard. Mathew "bduncan" wrote in message ... In column B I have our part numbers and in column A is our serial numbers. Is there a way I can group the serial numbers with the correspondingpart number with out doing this manually. Not every product number has serial numbers and the products that do may have only one serial number or many serial numbers depending on the quantities. Serial # Product # 104-214100 4243232 4334532 104-214101 104-214103 5342322 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Grouping and Sorting and Auto Filter | Excel Discussion (Misc queries) | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
How to AUTO SAVE as opposed to turning on auto recovery: EXCEL | Excel Discussion (Misc queries) | |||
Auto Filter and Grouping | Excel Discussion (Misc queries) | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions |