+ Reply to Thread
Results 1 to 5 of 5

Enter custom date range to show data

  1. #1
    Registered User
    Join Date
    12-09-2008
    Location
    San Diego
    Posts
    3

    Question Enter custom date range to show data

    Hello,

    I took an Excel course in college but am a bit rusty. I have a customer database that I created and I would like to see certain things after entering a date range that I specify. I uploaded a small excel sheet to show my database and what I'm looking to do.

    Basically I would like to enter a date range and see these answers:

    Total Orders in that date range
    Total unique orders in that date range
    List of customers (name included) who ordered more than once in that date range

    The only columns of data I need to use are: firstname, lastname and orderdate.

    Any help is much appreciated.

    Thanks,

    Eric
    Attached Files Attached Files
    Last edited by ericbsandiego; 12-11-2008 at 01:59 PM.

  2. #2
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671
    See the attachement

    Please let me know what the expected outcome is. This at least will give you an idea
    Attached Files Attached Files
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com
    (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com
    (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo

  3. #3
    Registered User
    Join Date
    12-09-2008
    Location
    San Diego
    Posts
    3
    Thanks for the reply! It is much appreciated. I understand how you calculated total orders. Though I should have made myself more clear regarding the unique orders and customers who ordered more than once.

    The quantity does not matter, only that the same customer ordered again. This is so that we can track who our regular customers are. If one of our customers has ordered twice, meaning they have ordered on two separate dates, we would like to have their names listed so that it is easy to compile a list. I'm not sure if this is possible in excel.

    For example, say we have three customers named Joe, David and Tom. Joe and David order once from 12/1/08-12/10/08 but Tom orders on two separate days in that period. 4 total orders have been placed however the total unique orders would be 3 since Tom's second order would not count.

    So in the total unique orders cell I'd like to have a number and in the list of customers cell I'd like to have names with both of these things being affected by the date range I chose.

    Example:
    Start Date 4/6/2008
    Finish Date: 6/14/2008
    Total Orders: 13
    Total Unique Orders: 12
    List of Customers Ordering >1: Last Name 1
    ................................................random name
    ................................................etc
    ................................................etc

    Thanks again!

    Eric

  4. #4
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    re: Enter custom date range to show data

    I hope you like it but I've made a VBA User Defined Functions to do this. WS function were not quit giving me the result I was hoping for:
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    12-09-2008
    Location
    San Diego
    Posts
    3
    Perfect! Thanks for your help!

+ 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