Results 1 to 8 of 8

Multiple Criteria and Partial Date Matching

Threaded View

  1. #1
    Registered User
    Join Date
    05-27-2010
    Location
    Cleveland, OH
    MS-Off Ver
    Excel 2010
    Posts
    51

    Multiple Criteria and Partial Date Matching

    I have 2 columns; one for product and one for date. The product column (text) includes 6 different products, and the date column (mm/dd/yyyy) lists when they were sold.(NOTE: there is a 3rd column which includes exact time product was sold, but that information is not part of this question.) So I have multiple occurrences where the product in column A matches the date in column B.

    I'm looking to truncate this information by month and by product into a nice table for visualization. I need to build an equation that counts how many of each product was sold in each month.

    My master list is enormous, so anything to keep this automated would be appreciated. Thanks in advance.
    Last edited by NBVC; 07-08-2010 at 11:27 AM.

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