+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Registered User
    Join Date
    05-08-2020
    Location
    Pasig City
    MS-Off Ver
    2016
    Posts
    2

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

    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?
    Attached Files Attached Files
    Last edited by dcadiz; 05-08-2020 at 04:31 AM. Reason: Added an attachment

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    17,940

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

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

  3. #3
    Registered User
    Join Date
    05-08-2020
    Location
    Pasig City
    MS-Off Ver
    2016
    Posts
    2

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

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to highlight or filter values in a table based on another condition
    By stevemalekano in forum Excel General
    Replies: 3
    Last Post: 05-31-2018, 04:39 AM
  2. VBA: Filter Pivot Table based on cell values
    By nicklasj in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-31-2015, 11:16 AM
  3. Replies: 8
    Last Post: 06-24-2014, 03:35 PM
  4. Filter Table with values based in worksheet
    By delboy2405 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2013, 03:50 AM
  5. Change pivot table filter with VBA based on cell values
    By ZeDoctor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2012, 09:03 AM
  6. Change Pivot table Filter Based on Cell Value *Multiple Filter items* Possible?
    By Flydd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2012, 06:57 AM
  7. Replies: 2
    Last Post: 02-11-2010, 03:12 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1