+ Reply to Thread
Results 1 to 7 of 7

Excel formula to filter by 2 criteria.

  1. 01-21-2025, 09:34 AM #1
    meraz
    meraz is offline
    Registered User
    Join Date
    11-25-2021
    Location
    India
    MS-Off Ver
    2021
    Posts
    57

    Excel formula to filter by 2 criteria.

    which excel formula, vba, power query is best for attached excel sheet, in excel sheet there two sheet name sheet1 and sheet2 in sheet1 there is main data table name main_DB from A1:D24 with heading name in sheet2 i want result in table name called result Which is in sheet2 A3:D26. In sheet2 there is two step to get result, 1st step to follow is in sheet2 B1 there is dropdown list of vendors from vendors list search that particular vendor and show result in sheet2 A3:D26 result table. 2nd step is after getting result vendor wise in result table then filter sheet2 A3:D26 with sheet2 criteria table G3:G26 by following criteria table.

    Sample Filter.xlsx
    Reply With QuoteRegister To Reply
  2. 01-21-2025, 09:35 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,181

    Re: Excel formula to filter by 2 criteria.

    Still using Excel 2016?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 01-21-2025, 11:10 AM #3
    windknife
    windknife is offline
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,868

    Re: Excel formula to filter by 2 criteria.

    Sheet2!A4
    Please Login or Register  to view this content.
    copied down and across.

    G4
    Please Login or Register  to view this content.
    copied down.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 01-21-2025, 11:27 AM #4
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,669

    Re: Excel formula to filter by 2 criteria.

    Attached is a Power Query Solution/
    1. Load each of the tables to PQ/
    2. Filter on the table in B1:B2
    3. Filter on the criteria table by doing a left join.

    See the file.
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  5. 01-21-2025, 11:45 AM #5
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,671

    Re: Excel formula to filter by 2 criteria.

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Named range "Filter_By"
    Attached Files Attached Files
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  6. 01-21-2025, 01:27 PM #6
    meraz
    meraz is offline
    Registered User
    Join Date
    11-25-2021
    Location
    India
    MS-Off Ver
    2021
    Posts
    57

    Re: Excel formula to filter by 2 criteria.

    now i am using 2021
    Reply With QuoteRegister To Reply
  7. 01-21-2025, 01:40 PM #7
    meraz
    meraz is offline
    Registered User
    Join Date
    11-25-2021
    Location
    India
    MS-Off Ver
    2021
    Posts
    57

    Re: Excel formula to filter by 2 criteria.

    professional plus 2021 excel version
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel FILTER FORMULA with 2 dimensional criteria
    By dxfoxd in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 02-29-2024, 05:48 PM
  2. [SOLVED] Add 2 Criteria to Filter Formula
    By billy60 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-29-2024, 10:59 AM
  3. [SOLVED] Multiple Criteria Filter Formula
    By billy60 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-28-2024, 05:21 PM
  4. Filter with criteria formula today
    By filnirv in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-28-2012, 03:47 PM
  5. Advanced Filter criteria (formula)
    By Gareth in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-20-2005, 05:20 PM
  6. [SOLVED] Adv Filter Formula Criteria
    By tjtjjtjt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2005, 09:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1