+ Reply to Thread
Results 1 to 3 of 3

filter list on new sheet based on due dates

  1. #1
    Registered User
    Join Date
    09-13-2010
    Location
    Christchurch, NZ
    MS-Off Ver
    MS Office Standard 2010
    Posts
    9

    filter list on new sheet based on due dates

    Hi guys, first time here, did a search but couldnt find what I was looking for - any help would be appreciated.

    Basically I want to make a spreadsheet where we can enter a list of deliveries to clients with the product delivered, the volume, quantity and when it was delivered. Then based on those volumes and a prescribed formula we can work out how long that product will last. I have worked this out pretty well I feel, however;

    I need help on trying to automagically filter this list into a new sheet and only display those clients that will run out of said products in the next 14 days so we can schedule a redelivery, preferably with little to no input from the user as the guy that will run it will have poor excel skills (not essential, I can teach him if needs be)

    Trying hard to concentrate and work this out atm but weve had a massive earthquake in the past week with over 500 shocks so far and im a bit stressed out, any help you guys can give would be much appreciated =)

    Basic example sheet attached, - want the filtered list on the REPORTS tab


    [EDIT] Solved thanks =)
    Attached Files Attached Files
    Last edited by AdamK; 09-15-2010 at 04:54 PM.

  2. #2
    Forum Contributor
    Join Date
    10-17-2007
    Location
    Washington, DC
    Posts
    103

    Re: filter list on new sheet based on due dates

    You were close. When entering your boolean expression to determine if a product needs to be delivered or not, you should have it return the row number if it needs to be included, rather than true. Then on your reporting tab you can key off of this column using the small function to return the row of information that needs to be included, combine with index to return and of the relevant columns.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-13-2010
    Location
    Christchurch, NZ
    MS-Off Ver
    MS Office Standard 2010
    Posts
    9

    Re: filter list on new sheet based on due dates

    Most excellent, thankyou for you stunning help =) I have never before used Row type functions so Ill have to teach myself what youve done for future use,

    Thanks again mate your a legend.

+ 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