+ Reply to Thread
Results 1 to 4 of 4

Advance Filter criteria "Not Equal to or greater than"

  1. #1
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Advance Filter criteria "Not Equal to or greater than"

    Hi,
    I have a data set that contains a date field as well.
    I want to apply advance filter where "DAte field is NOT Equal to or Not greater than another specific date"

    What will be the notation for that.

    Help would be greatly appreciated.
    Teach me Excel VBA

  2. #2
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Advance Filter criteria "Not Equal to or greater than"

    Sorry mind blockage.

    It will be actually less than a specific date

    <9/3/2019

  3. #3
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Advance Filter criteria "Not Equal to or greater than"

    Hi


    The condition you want to apply is always TRUE.

    See: Different is: < or >
    It is not greater than it is: < or =

    Either is: < or > or < or =

  4. #4
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Advance Filter criteria "Not Equal to or greater than"

    Thank you Jose for confirming. I realized it after I had posted the question.

+ 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. Problem with Advance filter on "or" Criteria
    By Eric Tsang in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-28-2018, 03:46 AM
  2. Replies: 0
    Last Post: 08-31-2016, 02:57 AM
  3. Replies: 6
    Last Post: 01-30-2015, 03:13 PM
  4. [SOLVED] Cell Formula to count time with "Greater Than or Equal to" and "Less Than"
    By chriswhite1982 in forum Excel General
    Replies: 3
    Last Post: 06-16-2013, 12:30 AM
  5. Filter report in pivot table with "greater than" and "less than"
    By gygabyte017 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-29-2012, 08:08 AM
  6. Filter using "not equal to" criteria using array
    By AlaaAlii in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-11-2012, 07:14 AM
  7. [SOLVED] sort data rows "greater than or equal" criteria in another cell
    By HV man in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-26-2006, 06:55 PM

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