| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a new table from another - filtering out unwanted data
Here is my table for sheet1:
Shipment No. Product No. of Pieces A pencil 1 B pen 1 A eraser 1 A paper clip 2 B stamp 3 C ruler 1 B calculator 2 I am trying to create a new table in a new sheet (sheet2) that will list all the products and pieces that were part of shipment no. A This is what I would like it to look like Product No. of Pieces pencil 1 eraser 1 paper clip 2 How do I go about doing this? Please help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table n filtering of data | Excel Worksheet Functions | |||
| Pivot Table - Filtering Data Field | Excel Discussion (Misc queries) | |||
| Filtering Pivot Table Data | Excel Discussion (Misc queries) | |||
| Filtering Pivot Table Data | Excel Discussion (Misc queries) | |||
| Filtering data from one pivot table against another | Excel Discussion (Misc queries) | |||
Threaded Mode
