Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I have a status column in a pivot table report that contains one of several values: - Signed off - QA Testing - Dev Testing - New - ... I currently include all values in my table, but would like to limit the items with status = "Signed Off" to only those items updated in the last week. I would like all other status values to remain as is (all items regardless of status in the report EXCEPT Signed Off, in other words. Signed Off should be limited by updated date.) I have a column containing the last updated date as well. Is it possible to create a filter to show Signed Off values only if the last update date is within 1 week AND show all other status values regardless of update date? Thanks, Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I filter multiple columns at once? | Excel Discussion (Misc queries) | |||
Filter based value in multiple columns | Excel Discussion (Misc queries) | |||
how do i filter multiple columns | Excel Worksheet Functions | |||
automatically filter out blanks in multiple columns | Excel Worksheet Functions | |||
how do I filter for 1 variable in multiple columns | Excel Worksheet Functions |