+ Reply to Thread
Results 1 to 4 of 4

Filter multiple columns

  1. #1
    Registered User
    Join Date
    03-11-2017
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    2

    Filter multiple columns

    I have a simple Excel spreadsheet consisting of a column containing song titles and adjacent columns recording dates of performance of each song (in date format). Some songs have only a few dates and some have many - all have been entered in sequence as they happen.
    I would like to search for all the songs used in, say, 2017. ie. to filter all the date columns at the same time.
    I tried Advanced filter but could not work out what to enter in the criteria field - everything I tried gave me an error message.
    Can you help?

  2. #2
    Registered User
    Join Date
    02-08-2017
    Location
    Greenwood, SC
    MS-Off Ver
    2010
    Posts
    18

    Re: Filter multiple columns

    If you could upload a sample excel file to show an example, it would be a lot more helpful.

    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    Click Advanced next to Quick Post button at the bottom right of the editor box.
    Scroll down until you see "Manage Attachments",
    Click the "Choose" button at the upper left (upload from your computer).
    Select your file, click "open", click "upload"
    Once the upload is completed the file name will appear below the input boxes in this window.
    Close the Attachment Manager window.
    Click "Submit Reply"
    Note: Please do not attach password protected workbooks/worksheets
    If my answer helped, say thanks. Add reputation.

  3. #3
    Registered User
    Join Date
    03-11-2017
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Filter multiple columns

    Attaching a sample file:
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    12-18-2016
    Location
    London
    MS-Off Ver
    Microsoft 2013
    Posts
    145

    Re: Filter multiple columns

    Try using the Data > Filter > AdvancedFilter, instead of the
    AutoFilter......it will allow "OR" conditions between columns.

    Let’s refer to article in the following thread which discusses about a similar and see if it helps: https://www.techonthenet.com/excel/f.../advanced2.php

+ 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. Filter Excel Data using vba multiple criteria multiple columns
    By pmyk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-28-2013, 01:32 AM
  6. Replies: 2
    Last Post: 06-15-2012, 05:34 PM
  7. Filter for date range across multiple columns and multiple worksheets
    By Pugface in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-02-2011, 05:30 AM

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