Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a spreadsheet that has several different "paragraphs" i.e. task lists
with people's initials. For example main header Admin duties and under that I have lots of tasks and names next to them telling who responsible of doing the tasks. Then I have another main header etc. etc. How do I do the filtering so that I can see all my duties that I am responsible of so that it will show me the main headers as well. I can select all and put a filter but the minute I ask it so show only my tasks it won't show the main headers. Any help would be very much appreciated |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Maybe instead of a header for Admin duties etc, you should arrange a
column for Tasks and this is filled for each person. Hope this helps. Pete On Aug 10, 11:34 am, Henna wrote: I have a spreadsheet that has several different "paragraphs" i.e. task lists with people's initials. For example main header Admin duties and under that I have lots of tasks and names next to them telling who responsible of doing the tasks. Then I have another main header etc. etc. How do I do the filtering so that I can see all my duties that I am responsible of so that it will show me the main headers as well. I can select all and put a filter but the minute I ask it so show only my tasks it won't show the main headers. Any help would be very much appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filtering data to new spreadsheet | Excel Discussion (Misc queries) | |||
Filtering Multiple Columns | Excel Worksheet Functions | |||
Excel 2003; spreadsheet with filtering; deleting rows | Excel Worksheet Functions | |||
Filtering for multiple sheets | Excel Discussion (Misc queries) | |||
MY SPREADSHEET IS NOT FILTERING CORRECTLY | Excel Discussion (Misc queries) |