| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter a range of data with multiple criteria
I have a worksheet with about 4000+ users (rows).
I need to filter out the data containing one of the four codes starting with A,D,L, or R. How can I create a formula that will search for the codes in the column starting with the above letters and return a TRUE if it is there and a FALSE if it is not. There are 8 columns per row. I just need to search in one column for the above text. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced Filter for multiple criteria, including blank cells | Excel Worksheet Functions | |||
| Create macro to filter on multiple criteria | Excel Worksheet Functions | |||
| self-sizing adv.filter criteria range | Excel Discussion (Misc queries) | |||
| Advanced filter and Criteria Range | Excel Discussion (Misc queries) | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
Threaded Mode
