+ Reply to Thread
Results 1 to 2 of 2

Filter as you type - multiple columns

  1. #1
    Registered User
    Join Date
    06-14-2012
    Location
    Fredrikstad, Norway
    MS-Off Ver
    Excel 365
    Posts
    9

    Filter as you type - multiple columns

    Hi Excel-gurus,

    Right to the point:
    I have created a list of all my karaokesongs in an Excel worksheet.
    The list is based on these columns:

    A: Disc-song (in the format XXX-XX)
    B: Song Title
    C: Artist
    D: Media (MP3+G or Video)
    E: File-path (based on A - C - B)

    What I want is to type a value in a cell, i.e. G1, and have the list automatically filtered.
    G1 should search in column B and C simultaneously, so I can enter artist OR song title and still find what I want.

    The results can either be filtered in the list as is, OR in a textbox by itself. The results should also contain column A through D.
    The point is to be able to search for an artist or title and quickly find the disc and number.

    Anyone have an idea how to solve this? Is it solvable?
    Last edited by borgja; 04-27-2016 at 09:07 AM.

  2. #2
    Registered User
    Join Date
    06-14-2012
    Location
    Fredrikstad, Norway
    MS-Off Ver
    Excel 365
    Posts
    9

    Re: Filter as you type - multiple columns

    By the way, I'm using Excel 2016

+ 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: 11-24-2014, 11:58 AM
  2. Using filter to highlight/filter duplicates in multiple columns but within 1 day
    By DaveBre in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-25-2014, 04:07 AM
  3. Macro to filter multiple columns of data to multiple work sheets
    By LISSANN in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-10-2014, 07:24 PM
  4. Filter multiple columns based on multiple data validation fields
    By Jhunnieboy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-30-2014, 03:41 PM
  5. vlookup type search from multiple columns
    By testbloke in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-23-2013, 08:29 AM
  6. Replies: 2
    Last Post: 06-15-2012, 05:34 PM
  7. Table Sorting When Multiple Columns Contain the Same Type of Data
    By blackholeinacan in forum Excel General
    Replies: 5
    Last Post: 03-09-2011, 12:20 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