+ Reply to Thread
Results 1 to 2 of 2

Filtering formula values in a table

  1. #1
    Registered User
    Join Date
    04-04-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    22

    Filtering formula values in a table

    Hello,

    In the attached file, all the values B11:E13 are returned from data in different tabs using using vlookup or index functions
    I have a requirement where the data in B11:E13 should be filtered based on the filter value selected in B7.

    1) None of the formula in B11:E13 have any criteria or validation for the Account Type value in B7. So none of the formula check if Account Type.
    2) If I add a table to map Sector1, Sector2 and Sector3 as Premium or Regular(the values in B7), is there a way to filter out the data in B11:E13 based on the filter value selected in B7.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    mysore
    MS-Off Ver
    Excel 2007
    Posts
    4,982

    Re: Filtering formula values in a table

    Add column F as shown in file. Then Filter option can be executed.
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

+ 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. Filtering out specific values from a table
    By armando12345 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-24-2019, 04:06 PM
  2. [SOLVED] Filtering table with multiple cell values
    By stumabe in forum Excel General
    Replies: 6
    Last Post: 11-12-2014, 12:00 PM
  3. [SOLVED] how can i sum pivot table filtering some values another table
    By moogii1102 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-19-2014, 02:17 AM
  4. Filtering By Values In Pivot Table (pic included)
    By no.18shirt in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-11-2013, 06:02 PM
  5. Filtering By Values In Pivot Table (pic included)
    By no.18shirt in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-11-2013, 04:56 PM
  6. Filtering values in a pivot table
    By vsm in forum Excel General
    Replies: 3
    Last Post: 11-16-2011, 11:41 PM
  7. Problem to put table row values (after filtering) into other form
    By NatanZ in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-04-2011, 07:24 AM

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