+ Reply to Thread
Results 1 to 2 of 2

Can I filter a list using cell values instead of autofilter?

  1. #1
    Registered User
    Join Date
    07-30-2010
    Location
    South Pole
    MS-Off Ver
    Excel 2010
    Posts
    99

    Can I filter a list using cell values instead of autofilter?

    We have a requirement of 5 sales a day.
    I have an excel 2003 sheet as follows with each user sales:

    21 May|5
    22 May|4
    23 May|5
    29 May|6
    30 May|2
    1 June |5
    5 June |4

    I want to [custom] filter the list to contain all values between 22 May and 4 June (for example) and I would like a cell that states
    1)"Should have made this many sales", another that states
    2)"has made this many sales" and another that states
    3)"this many sales to make up".

    2) is fine with a subtotal fx of column b and 3) is just 1) minus 2) but I am having issues with 1). What I currently am doing is subtracting the min from max of the subtotal of column a. However, this will only work if the dates picked in the autofilter actually exist in the log (a user could be away on the last few days of the upper limit, as in the example) and if that is not the case then it will state the number of sales that should have been made while the user has been logged.

    Two unreasonable solutions:
    a)Type the values in the custom autofilter field and in two other cells and have 1) and 3) reference these cells;
    b)After the autofilter values have been typed, check to see if the upper and lower values appear in the log otherwise, just type them below.

    Suggestied solution:
    type the values in seperate cells and have the autofilter pick up these values? (I have read this: http://www.excelforum.com/excel-prog...e-in-cell.html but it is not what I am looking for).

    Any reasonable solutions? I'm trying to do this without macros. Although I know how to write macros, I do not want to confuse the users with the dialog boxes and buttons.

    THANK YOU!!

  2. #2
    Registered User
    Join Date
    07-30-2010
    Location
    South Pole
    MS-Off Ver
    Excel 2010
    Posts
    99

    Re: Can I filter a list using cell values instead of autofilter?

    I did not know that I could use advanced filter to use cell values.

    I have used that for the solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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