+ Reply to Thread
Results 1 to 3 of 3

Filter/Find by a variety of items

  1. #1
    Registered User
    Join Date
    03-21-2020
    Location
    Michigan
    MS-Off Ver
    Office for Mac
    Posts
    9

    Filter/Find by a variety of items

    Hello,
    Attached is a basic spreadsheet. What I need help figuring out is how to be able to search for a student in the list who meets a set of criteria.

    For example, I would search for: "BPA, Ultimate Frisbee" and Jon Perrot would display. If I searched for: "DECA, Fishing" then Tristan Frankless would appear.

    Can someone help me?! Thank you!!
    Last edited by FDibbins; 07-13-2020 at 11:04 PM.

  2. #2
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,616

    Re: Filter/Find by a variety of items

    Would just data > autofilter on col-I do it?
    Select text filters > Custom filter
    This allows you to select 2 conditions via either "and" or "or".
    Geoff

    Did I help significantly? If you wish, click on * Add Reputation to say thanks.
    If your problem has been resolved please select ?Solved? from the Thread Tools menu

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Filter/Find by a variety of items

    That file looks like it contains real data (only 2 rows, but still), I have removed the file...it is never a good idea to post personal info on a public forum.

    having said that, you dont actually show what your expected outcome would look like? Could you add some dummy daya and show what you expect, and how you would base teh extract?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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] Filter Data Based on Unique Column Items and Save the Workbook with Filtered Items
    By IonutC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-18-2019, 03:08 AM
  2. [SOLVED] I need formula or macro to filter a number of items from different tables at single filter
    By Karthikeyannb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2014, 11:04 AM
  3. VBA - Advanced Filter / Find Row Items to Remove Based on Multiple Criteria
    By aferoz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-03-2014, 09:56 AM
  4. macro to filter all items in Autofilter except 2+ items
    By DanRiverBrew in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-09-2013, 09:15 PM
  5. 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
  6. Excel 2007 : Report Filter Multiple items/All items
    By Ganivada in forum Excel General
    Replies: 2
    Last Post: 11-30-2009, 05:45 AM
  7. Extract filter items from Drop-Down Automatic Filter
    By karpatov in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2006, 02:10 PM

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