Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting more than one filter values
I filtere a column having A,B,C,R groups. When i click A then rows related to A are selected and the rest is hidden as we know it. But how to select A and R at the same time so i can view both A and R groups. Regards... -- jamex ------------------------------------------------------------------------ jamex's Profile: http://www.excelforum.com/member.php...o&userid=32243 View this thread: http://www.excelforum.com/showthread...hreadid=523855 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting more than one filter values
Use an advanced filter
-- AP "jamex" a écrit dans le message de ... I filtere a column having A,B,C,R groups. When i click A then rows related to A are selected and the rest is hidden as we know it. But how to select A and R at the same time so i can view both A and R groups. Regards... -- jamex ------------------------------------------------------------------------ jamex's Profile: http://www.excelforum.com/member.php...o&userid=32243 View this thread: http://www.excelforum.com/showthread...hreadid=523855 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting more than one filter values
You can have two criteria in data|autofilter.
Choose Custom from the dropdown filter arrow. You'll see a couple of spots where you can specify your criteria (and you can use and/or logic when you do it). Click on those dropdowns and you'll see lots of things that may help: Begins with contains ends with is greater than is greater than or equal equal to and a few more. But it is limited to just two criteria. jamex wrote: I filtere a column having A,B,C,R groups. When i click A then rows related to A are selected and the rest is hidden as we know it. But how to select A and R at the same time so i can view both A and R groups. Regards... -- jamex ------------------------------------------------------------------------ jamex's Profile: http://www.excelforum.com/member.php...o&userid=32243 View this thread: http://www.excelforum.com/showthread...hreadid=523855 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I break values apart that are in the same cell? | Excel Worksheet Functions | |||
Pivot table page filter not accepting multiple values. Workaround? | Excel Worksheet Functions | |||
Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
Selecting data from a list based on entered values | Excel Discussion (Misc queries) | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |