+ Reply to Thread
Results 1 to 2 of 2

How to create a filter database that will recognize individual entries w/in cell

  1. #1
    Registered User
    Join Date
    08-29-2018
    Location
    Indiana, US
    MS-Off Ver
    2016
    Posts
    36

    How to create a filter database that will recognize individual entries w/in cell

    Hello!

    I am trying to create a drop down menu that will let me filter through order types in order to view specific tests that were run. However, sometimes there are multiple tests ordered. I need the database to still show me "HIV, Urine Culture, Pap Smear" when I've selected "Pap Smear" from the drop down menu. I also don't want it to create a new menu option for these multiple listings. I only want a new menu option to be created when I enter a single item. Any help would be greatly appreciated!! Thank you!!


    For example, if I added "Blood Draw" to D20, I want that to automatically be added as an option to the drop down menu. But if I were to add "Blood draw, Pap Smear, HIV" I don't want that to become an option. Also, if I selected "HIV" from the drop down menu, I'd want the entry "Blood draw, Pap Smear, HIV" to still appear. I would also want it to appear regardless of whether it typed "HIV" or "hiv" or, for another example, "Pap smear" vs "Pap Smear".

    Any and all help is greatly appreciated!! Thank you!!
    Attached Files Attached Files
    Last edited by Klea; 06-29-2021 at 01:22 PM.

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: How to create a filter database that will recognize individual entries w/in cell

    Possibly adding wildcard notation to the autofilter criteria...
    Please Login or Register  to view this content.

+ 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. Macro to Filter by PVT, Copy and Create Individual Files
    By GCLIFTON in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-09-2016, 01:48 PM
  2. Replies: 5
    Last Post: 02-26-2016, 12:59 PM
  3. Formula or Code to recognize and separate multiple entries within a cell
    By MichaelMcDaniel in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-13-2014, 12:53 PM
  4. Filter does not recognize cell as a date
    By kmarie630 in forum Excel General
    Replies: 1
    Last Post: 09-24-2014, 06:20 PM
  5. Using advanced filter to create new sheets based on database
    By eighty2scrambler in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2009, 03:58 PM
  6. Separate multiple entries in cell to individual cells
    By Jim15 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2005, 12:04 PM
  7. [SOLVED] how can I create a ODBC database in excel-check for duplicate field entries
    By Deler9 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-30-2005, 10:05 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