| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping data grouped when Filtering
I have a spreadsheet where each column has a header cell ("Status, Priority,
Responsiblity, etc). Then I have the data broken up in groups, with one row acting as the group header. (Software, Electrical Mechanical, etc) I want to filter the data to only show items where the Status cell contains 'Complete'. But I want my groups to stay in tact, leaving the row headers in place. What is the best solution? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Median calculation of grouped data. | Excel Worksheet Functions | |||
| Group data and maintain grouped data on dedicated pages | Excel Worksheet Functions | |||
| How to retrieve grouped items data | Excel Discussion (Misc queries) | |||
| Filtering grouped worksheets | Excel Discussion (Misc queries) | |||
| Filtering out single values (keeping only repeating data) | Excel Discussion (Misc queries) | |||
Threaded Mode
