+ Reply to Thread
Results 1 to 2 of 2

Filtering the rows based on criteria

  1. #1
    Registered User
    Join Date
    06-06-2017
    Location
    GERMANY
    MS-Off Ver
    EXCEL 2013
    Posts
    32

    Filtering the rows based on criteria

    I have an sheet, where i would like to filter the blank rows in column T and U.

    I have certain cases to be considered.

    I have few missing rows and have denoted them as missing in column S. If they are missing, I dont want them to be considered for filter condition. In Default they are blank.

    The other case is, any one of the rows in column T and U are found blank, has to be filtered. IF both the column are blank also have to be filtered.

    I have attached an Image for reference. Could anyone suggest me how I could do it ? I am a beginner in VBA ,Any lead would be helpful.

    Please Login or Register  to view this content.
    tried the above code, It works with column T. How can i include multiple criteria. because with my cases, with column S as missing, I dont Need to consider the complete row. and with my T and U, both blank or any one is blank, then i Need them to be filtered.

    Capture1.PNG This is the sample sheet.
    Capture2.PNG This is how, I would like to have my result. Such a way that, it neglect the rows containing missing., then it considers the blank rows in column T and U. In the Image, Please ignore the row2, it is by mistake.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Filtering the rows based on criteria

    Try:

    Please Login or Register  to view this content.
    If that doesn't work - Attach a sample workbook. Make sure there is just enough data to demonstrate your need. 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 shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ 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. Filtering a Checklist based on different criteria
    By uremumson1991 in forum Excel General
    Replies: 1
    Last Post: 08-03-2014, 01:10 PM
  2. [SOLVED] Filtering Based on criteria
    By skate1991 in forum Excel General
    Replies: 18
    Last Post: 05-16-2013, 11:08 AM
  3. [SOLVED] Filtering based on criteria
    By fulldeen in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-18-2012, 02:08 PM
  4. Filtering data according to 2 criteria within rows
    By grafx77 in forum Excel General
    Replies: 4
    Last Post: 07-06-2012, 05:50 PM
  5. Filtering based on variable criteria
    By banana-pumpkin in forum Excel General
    Replies: 2
    Last Post: 09-13-2010, 11:17 AM
  6. Filtering data based on criteria
    By rhudgins in forum Excel General
    Replies: 6
    Last Post: 04-15-2010, 02:03 PM
  7. Filtering a block of rows based on one criteria???
    By WarrenC in forum Excel General
    Replies: 1
    Last Post: 01-10-2007, 01:04 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