Any formula to filter a table based on one or more cell values without using VBA

**dcadiz** · 05-08-2020, 04:14 AM

I've tried using VBA and while it does the trick, it is now actually what I'm looking for.

I need something that is automatic such that when I input the data in a cell, it will automatically filter the whole table based on that particular cell value.

What functions are out there that can do this trick?

**alansidman** · 05-08-2020, 04:23 AM

Read the yellow banner at the top of this page on how to upload a file

**dcadiz** · 05-08-2020, 04:32 AM

Attached a sample file for reference where values are to be input in A2 and/or B2 to filter out the whole table. Thank you

Any formula to filter a table based on one or more cell values without using VBA

LinkBack

Thread Tools

Rate This Thread

Display

Any formula to filter a table based on one or more cell values without using VBA

Re: Any FUNCTION to filter a table based on one or more cell values without using VBA

Re: Any FUNCTION to filter a table based on one or more cell values without using VBA

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to highlight or filter values in a table based on another condition

VBA: Filter Pivot Table based on cell values

Using VBA to select multiple values in a pivot table report filter based on a cell value

Filter Table with values based in worksheet

Change pivot table filter with VBA based on cell values

Change Pivot table Filter Based on Cell Value Multiple Filter items Possible?

Filter a table with an OR logic based on columns values

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions