+ Reply to Thread
Results 1 to 4 of 4

Filtering Problem

  1. #1
    Registered User
    Join Date
    10-23-2015
    Location
    Houston, TX
    MS-Off Ver
    Excel 2010
    Posts
    26

    Filtering Problem

    Hello everyone!
    I need to view invoices with order amounts that are either less than 100 or greater than 5000 under the amount filter sheet. I tried filtering it but it is not working. I need to review the order amount filter worksheet, and fix it. How do I do this?
    /Here is the attachmentAttachment 428266.
    Last edited by kis; 11-02-2015 at 12:14 PM.

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Filtering Problem

    Click on the filter button on the Order Amount column.
    Click on Number Filters , Custom Filter
    Select Is Greater than and enter 5000
    Click on OR
    Select Is Less Than and enter 100
    Click OK
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    10-23-2015
    Location
    Houston, TX
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: Filtering Problem

    I did that but its not working.

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Filtering Problem

    Thread posted in Commercial Services.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

+ 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 Problem
    By ndorey in forum Excel General
    Replies: 8
    Last Post: 02-28-2014, 10:17 PM
  2. input box problem, cell filtering problem, result display while locking sheet
    By croozin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2013, 08:52 AM
  3. problem with filtering
    By zazzz in forum Excel General
    Replies: 3
    Last Post: 07-31-2013, 03:22 PM
  4. Filtering problem
    By a.janmohammadi in forum Excel General
    Replies: 4
    Last Post: 11-14-2012, 04:41 AM
  5. problem with filtering
    By bluebird1234 in forum Excel General
    Replies: 3
    Last Post: 04-12-2008, 03:30 PM
  6. Filtering problem
    By cgm73 in forum Excel General
    Replies: 1
    Last Post: 01-12-2007, 07:05 PM
  7. Help with filtering problem
    By mspinella in forum Excel General
    Replies: 4
    Last Post: 05-22-2006, 01:10 PM
  8. Filtering problem
    By gaftalik in forum Excel General
    Replies: 5
    Last Post: 10-07-2005, 12:05 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