+ Reply to Thread
Results 1 to 2 of 2

Need help please

  1. #1
    Registered User
    Join Date
    10-13-2022
    Location
    morocco
    MS-Off Ver
    2019
    Posts
    2

    Need help please

    Is it possible to find cells using multiple values in excel?
    Example:
    We have:
    1 LiamOlivia
    2 OliviaEmma
    3 LiamCharlotte
    4 ElijahCharlotte
    So here I want excel to find cells containing ?Olivia or Liam?. the result should be 1, 2, and 3.
    The idea is to find multiple values, not just one.
    Just imagine if I have 1000 cells and want to find cells containing one from 50 keywords (values). is it possible?
    image_2022-10-14_014503420.png

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,496

    Re: Need help please

    You can place a filter on the top row and then use filter and contains.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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