+ Reply to Thread
Results 1 to 5 of 5

Find macro - multiple criteria

  1. #1
    Forum Contributor
    Join Date
    01-22-2022
    Location
    UK
    MS-Off Ver
    365
    Posts
    130

    Find macro - multiple criteria

    Is it possible to search for cells with more than 1 criteria.

    Example, search for "this" and "that", would go to cell C4.

    The criteria is that multiple values have to be found (AND, not OR).

    Capture.PNG

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Find macro - multiple criteria

    What do you actual mean with "would go to cell C4"?
    I would offer 3 answers:
    1- cell contents:
    Please Login or Register  to view this content.
    2- row number
    Please Login or Register  to view this content.
    3- cell address:
    Please Login or Register  to view this content.
    Attachment 842505
    Attached Images Attached Images
    Last edited by bebo021999; 09-12-2023 at 10:31 PM.
    Quang PT

  3. #3
    Forum Contributor
    Join Date
    01-22-2022
    Location
    UK
    MS-Off Ver
    365
    Posts
    130

    Re: Find macro - multiple criteria

    Thanks for responding.

    I should have made it more clear but it would be to like the Find command, so it would go to the cell, and other cells after that.


    Attachment 842518
    Attached Images Attached Images

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Find macro - multiple criteria

    May be:
    In "Find & Replace":

    Find what: this * that

  5. #5
    Forum Contributor
    Join Date
    01-22-2022
    Location
    UK
    MS-Off Ver
    365
    Posts
    130

    Re: Find macro - multiple criteria

    Thanks very much bebo, did not think it would be as easy as this.

+ 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. Replies: 5
    Last Post: 05-24-2019, 04:48 PM
  2. Referencing one name find multiple criteria multiple results within a date range
    By Flora Lastra in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-14-2018, 04:47 PM
  3. Trying to find median & average for multiple columns with multiple criteria
    By help-meplease in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-11-2016, 06:59 PM
  4. Replies: 2
    Last Post: 05-26-2015, 07:29 PM
  5. Find multiple values with multiple criteria in vba macro
    By Jovillanueva in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 10-02-2014, 09:46 PM
  6. Replies: 4
    Last Post: 09-18-2012, 10:54 AM
  7. Replies: 2
    Last Post: 05-10-2012, 10:38 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