+ Reply to Thread
Results 1 to 3 of 3

Returning values that meet a user's criteria

  1. #1
    Registered User
    Join Date
    07-26-2016
    Location
    Pennsylvania
    MS-Off Ver
    2013
    Posts
    5

    Returning values that meet a user's criteria

    My goal is to allow a user input a certain product number, date range, and state/zone/district (where customer is located). From this I am trying to have excel pull all the customer names that have not purchased the specified product in the specified date range. I have tried researching but have been unable to find any results that helped. Any ideas would be great! Thank you.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,650

    Re: Returning values that meet a user's criteria

    Try advanced filter. See introduction: http://www.contextures.com/xladvfilter01.html
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    07-26-2016
    Location
    Pennsylvania
    MS-Off Ver
    2013
    Posts
    5

    Re: Returning values that meet a user's criteria

    So based on the user input, they want to see any customer in the NA region, 021-1 district, North Zone, who has not purchased product 123 in 2 months.

    My main end goal is to have excel auto populate a list with customer names that meet the criteria set by the user.
    Attached Files Attached Files
    Last edited by bneed; 07-26-2016 at 11:15 AM.

+ 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. Returning data for entries that meet a criteria
    By BWellman in forum Excel General
    Replies: 2
    Last Post: 08-27-2015, 12:43 AM
  2. Display top five values that meet criteria
    By themob212 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-11-2015, 02:29 PM
  3. how to add all values above row that meet multiple criteria criteria
    By skikio in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-18-2015, 09:40 AM
  4. [SOLVED] Returning values from a table if they meet a criteria of an IF statement
    By jkwlvsky in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-29-2014, 02:40 PM
  5. Macro for analyzing data and returning lines that meet certain criteria
    By Tdunlap in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2012, 08:32 PM
  6. Returning Multiple Values/Strings that meet a set of Arguements
    By jtb2005 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-17-2011, 09:51 PM
  7. Totalling up values that meet two criteria
    By johnmitch38 in forum Excel General
    Replies: 5
    Last Post: 06-04-2009, 05:49 AM

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