+ Reply to Thread
Results 1 to 3 of 3

How to put a search box that searches range of cells containing comma separated values?

  1. #1
    Registered User
    Join Date
    07-25-2019
    Location
    North America
    MS-Off Ver
    365
    Posts
    2

    How to put a search box that searches range of cells containing comma separated values?

    How can I place a search box in my spreadsheet that searches a range of cells containing comma separated keywords?

    I've attached a screenshot\edit to sort of get at what I'm trying to do. Let me know if you need any clarification on what I'm trying to accomplish!

    nwFkT71.jpg

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: How to put a search box that searches range of cells containing comma separated values

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and click Manage Attachments to open the upload window.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    07-25-2019
    Location
    North America
    MS-Off Ver
    365
    Posts
    2

    Re: How to put a search box that searches range of cells containing comma separated values

    I've attached a sample workbook:
    Attached Files Attached Files

+ 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] Vlookup or Index to search and return multiple values in one cell separated by a comma
    By Trnecessary in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 10-17-2018, 12:59 PM
  2. Vlookup or Index to search and return multiple values in one cell separated by a comma
    By Trnecessary in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2018, 10:37 AM
  3. [SOLVED] Populate Listbox From a range of cells AND comma separated values
    By Code Flunkie in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-10-2015, 11:13 AM
  4. How to Separately put comma separated values in adjacent cells
    By en19ma in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-06-2012, 01:30 AM
  5. Convert range of cells to comma separated list
    By maw230 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-23-2012, 06:03 PM
  6. Re: summing comma separated values in a range
    By rjamison in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2005, 08:05 PM
  7. [SOLVED] summing comma separated values in a range
    By bthoron in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-20-2005, 01: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