AutoFilter - Using Selectable Rows

Ralph Wiggum

New Member
Joined
Aug 7, 2007
Messages
5
(first time poster, long time reader)

Greetings,

There's probably a ridiculously simple answer to this but for the life of me, I can't find it anywhere.

If I create a pivot table, I'm able to click the arrow to the right on my row header, unselect "Show All" and then manually check boxes next to the rows I want to show. The pivot table then shows only the rows I'm interested in.

I can't figure out how to do this with filtering outside of the pivot table. I can select AutoFilter and then select "All", "Top 10" or individual rows, but I don't have the option to use a checkbox style selection to choose multiple, but not all, rows.

How can I set this up to have checkboxes associated with the AutoFilter dropdown so I can pick and choose which rows show?


thanks.
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
You can't.:)

That just isn't a feature of Autofilter.

Could you not use the Custom option?
 
Upvote 0
The custom option requires you to keep picking values from the drop down list and clicking the "or" and "equals" values, so it's a bit clunky for my intended purpose. Also, I'm not even sure it can be used with more than two parameters.

So to rephrase the question, if I've got data configured the following way:

Column A/B/C

Jones/Red/Blue
Smith/Green/Blue
Thomas/Yellow/Orange
Doe/Green/Blue
etc..

how can I create a filter that has a drop down box or checkbox system to select all the people I want to see line items for? (i.e. select 'Jones' and 'Thomas' so that I only see their values and not all the other rows.)

thanks.
 
Upvote 0
Why not use advanced filter instead of auto filter?
 
Upvote 0
I've tried, but it doesn't work. When I select Advanced Filter, filter the list in place and select $A:$A as the range, it doesn't work.

So either I can't figure out how to use it correctly, or it's not giving me the check box option to select displayed rows that I need.


Thanks for your patience.
 
Upvote 0
There is no check box option for advanced filter either.

That functionality just doesn't really exist.:)

You say the Advanced Filter didn't work? How?

Did you specify criteria?
 
Upvote 0
I can get the advanced filter to work, however running it with the qualifying criteria each time the end user uses the report isn't plausible.

I was really hoping for a checkbox system where you check the values which you want to see.

If a Pivot Table could return text values, I'd be all set. Unfortunately, it can't.
 
Upvote 0
There just isn't a checkbox system inherently built in.

You could probably create a userform with a listbox to simulate one though.
 
Upvote 0
Did you look at the link I posted?
It shows you exactly how to do what you are asking.
 
Upvote 0

Forum statistics

Threads
1,213,561
Messages
6,114,315
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top