| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Soting Various Lists
I have to excel lists, one exported from a database, the other I created.
The first sheet is of Equipment Records with the following columns: Itemname(Column A), Itemdescription(Column B). The second sheet is a list of parts for the various equipment records: Partname(Column A), Partdescription(Column B), Itemname it belongs to(Column C). How do I make a sheet 3 that shows all Items from sheet 1 with any parts from sheet 2 that they might have sorted under them? Output Example: Item001 Chainsaw Part015 Bar Part023 Chain Item002 Pole Item003 Mower Part006 Blade Part007 Belt |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Soting Various Lists
Try using subtotals. Data-Subtotals.
"Blissfully Ignorant" wrote: I have to excel lists, one exported from a database, the other I created. The first sheet is of Equipment Records with the following columns: Itemname(Column A), Itemdescription(Column B). The second sheet is a list of parts for the various equipment records: Partname(Column A), Partdescription(Column B), Itemname it belongs to(Column C). How do I make a sheet 3 that shows all Items from sheet 1 with any parts from sheet 2 that they might have sorted under them? Output Example: Item001 Chainsaw Part015 Bar Part023 Chain Item002 Pole Item003 Mower Part006 Blade Part007 Belt |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to clear validation lists based on other validation lists | Excel Discussion (Misc queries) | |||
| LISTS- adding info without repeat to other lists | Excel Discussion (Misc queries) | |||
| Lists referencing lists...is it possible? | Excel Worksheet Functions | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
| lists from other lists in excel | Excel Worksheet Functions | |||
Linear Mode
