| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Query on Category & Sub-category
I have a master data in excel (Category & Sub-Category).
1. When I select on Product category, I should get the sub-category values specific to that category. 2. I want to keep the master data seperate excel sheet. Kindly let me know how to do this. Excel Sheet1 Product Category Product sub Category Prod1 Sub-Prod1-1 Prod1 Sub-Prod1-2 Prod1 Sub-Prod1-3 Prod2 Sub-Prod2-1 Prod2 Sub-Prod2-2 Prod2 Sub-Prod2-3 Prod2 Sub-Prod2-4 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I display category | Excel Worksheet Functions | |||
| Filtering Out One Category | Excel Discussion (Misc queries) | |||
| Axis category | Charts and Charting in Excel | |||
| Summarizing category | Excel Discussion (Misc queries) | |||
| how can i add a category to XY-graph? | Charts and Charting in Excel | |||
Threaded Mode
