| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidating information
I have eleven different sub assemblies customers can choose from. The
customer can choose 1 to 3 of those sub assemblies to complete the final assembly. Is there a way to consolidate the information when I do a total materials used page so I dont have a bunch of 0s taking up a lot of space? This is what Im looking for: Before SUSPENSION KIT MATERIAL QUANTITY UNIT Hendrickson AA230L 0 PIECES Hendrickson AA230T 0 PIECES Hendrickson AA250L 0 PIECES Hendrickson AA250T 2 PIECES Hendrickson AA300L 0 PIECES Hendrickson AA300T 0 PIECES Hendrickson AANT23K 0 PIECES Hendrickson PARALIFT 1 PIECES Hutchens 49" TANDEM 0 PIECES Hutchens 49" TRI AXLE 0 PIECES Hutchens 57.5" TRI AXLE 0 PIECES After SUSPENSION KIT MATERIAL QUANTITY UNIT Hendrickson AA250T 2 PIECES Hendrickson PARALIFT 1 PIECES |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Consolidating a formula | Excel Worksheet Functions | |||
| Consolidating text information | Excel Discussion (Misc queries) | |||
| Consolidating Rows | Excel Discussion (Misc queries) | |||
| Consolidating information from one sheet to a list on another | Excel Discussion (Misc queries) | |||
| Consolidating??? | Excel Discussion (Misc queries) | |||
Threaded Mode
