Closed Thread
Results 1 to 3 of 3

Can "Advanced Filter" feature search for a person's name across MULTIPLE columns?

  1. #1
    Registered User
    Join Date
    09-04-2021
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    12

    Can "Advanced Filter" feature search for a person's name across MULTIPLE columns?

    I have an Excel index to organize information for a collection of photographs. See the attached sample worksheet.

    Because one photo may have more than one person in it, I have created multiple columns for their names (Person1, Person2, Person3, etc.)

    I want to be able to filter the spreadsheet to display only those rows that contain the name of a particular person. My problem is that the person's name may be located across MULTIPLE possible columns (Person1, Person2, Person3, etc.).

    Can the "Advanced Filter" feature be successfully be used for this? If not, is there another way to accomplish this?

    THANK YOU!!
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,607

    Re: Can "Advanced Filter" feature search for a person's name across MULTIPLE columns?

    This is a duplicate thread, and you are only allowed one thread per topic on the forum. Continue in your other thread, where you have an answer.

    Pete

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,901

    Re: Can "Advanced Filter" feature search for a person's name across MULTIPLE columns?

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: link to be added here
    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

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Trying to "Reset" advanced filter on multiple sheets with one button.
    By Cpayne19 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-08-2020, 01:15 AM
  2. advanced and complex "fuzzy" filter on multiple criteria
    By Ebru in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-03-2016, 03:11 PM
  3. Replies: 7
    Last Post: 03-17-2014, 01:51 PM
  4. [SOLVED] Emulate Excel 97 getopenfilename "Advanced" find including "Search subfolders"
    By FORTRANguru in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-06-2014, 08:21 PM
  5. [SOLVED] advanced filter criteria "begins with" and "does not begin with"
    By Eddie O in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 06:05 AM
  6. [SOLVED] "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du
    By TC in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-11-2005, 10:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1