Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I've got a table of data that I'm working with and trying to get displayed
the way I need it. There's a "Status" column that has one of 4 valid status values in it. I've used autofilter to see individual cuts of each status, but I'd also like to be able to set up a filter that would allow me to see all non-valid status at the same time without having to specify what they are (ie - show me any row where the status isn't one of the 4 valid options). For example: Status (in column N) ------- New Hold Active Close sales postpone So the advanced filter would allow me to see all rows with "sales" or "postpone" as a status. Thanks for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to create a scatter chart with 2 "X" values with common "Y"s | Charts and Charting in Excel | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
cannot use "Create List" and "Share Workbook" same time | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions |