+ Reply to Thread
Results 1 to 6 of 6

Multiple words in a single cell. Possible to filter words separately in the dropdown menu?

  1. #1
    Registered User
    Join Date
    01-29-2020
    Location
    Los Angeles
    MS-Off Ver
    Excel 2016
    Posts
    3

    Multiple words in a single cell. Possible to filter words separately in the dropdown menu?

    Cell in row 1 has "red, blue, yellow"
    Cell in row 2 has "red, green, purple"
    Cell in row 3 has "orange, purple"

    Is it possible to filter these separately in the drop-down menu? For example, if I pulled down the drop-down menu, I'd see separate checkboxes for "red", "blue", "yellow", "green", "purple", and "orange". And if I checked "red"...only rows 1 and 2 would show up. If I checked "purple"...only rows 2 and 3 show up. Etc.

    Anything like this possible?

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

    Re: Multiple words in a single cell. Possible to filter words separately in the dropdown m

    Yes, in the filter drop-down just above the area that displays the distinct values, you will see a Text Filters choice, and if you click on this you will get another drop-down to the right with a number of other ways of filtering the data. Click on the Contains... button, and then you can enter the word(s) you are looking for.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    01-29-2020
    Location
    Los Angeles
    MS-Off Ver
    Excel 2016
    Posts
    3

    Re: Multiple words in a single cell. Possible to filter words separately in the dropdown m

    Thanks for the reply Pete.

    Sorry, I should've clarified better. I'm producing this for a client. And while I could provide a list of all the possible searchable keywords (e.g., red, blue, yellow, etc.)...I was hoping there was a way to have them already present on the drop-down menu. Just one less thing to clutter up the spreadsheet and to streamline the process.

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

    Re: Multiple words in a single cell. Possible to filter words separately in the dropdown m

    You could do something similar using formulae, and extract the "filtered" data to another sheet. In that sheet you, or the client, can type in the word (or select it from a drop-down) that you want to filter on, and the data would automatically appear.

    Hope this helps.

    Pete

  5. #5
    Registered User
    Join Date
    01-29-2020
    Location
    Los Angeles
    MS-Off Ver
    Excel 2016
    Posts
    3

    Re: Multiple words in a single cell. Possible to filter words separately in the dropdown m

    Thanks again.

    This seems to be well above my skill-level for Excel. Do you know of any good tutorials that might outline how to do this? Or some keywords I could search that might cover this process?

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

    Re: Multiple words in a single cell. Possible to filter words separately in the dropdown m

    Here are two links to threads in this forum which show how this can be done:

    https://www.excelforum.com/excel-for...ext-sheet.html

    and

    https://www.excelforum.com/excel-gen...first-row.html

    You should be able to pick up some tips from those.

    Hope this helps.

    Pete

+ 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: 10
    Last Post: 10-16-2017, 09:07 AM
  2. Search multiple words in a single cell macro
    By ruissu in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-08-2016, 01:33 PM
  3. Search multiple words in a single cell
    By ruissu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2016, 10:40 AM
  4. Search multiple words in a single cell
    By ruissu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2016, 10:38 AM
  5. [SOLVED] How to set multiple colors to words in single cell when character matched?
    By bezbid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-08-2015, 01:41 PM
  6. Macro to only keep 100 words in a range of single words per column
    By PiaHarrison in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-03-2014, 08:57 PM
  7. Highlight cell with many words, with duplicates from row with single words.
    By Meows in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2010, 08:27 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