+ Reply to Thread
Results 1 to 4 of 4

Drop down list gives data per year and month

  1. #1
    Forum Contributor
    Join Date
    03-23-2015
    Location
    Manila, Philippines
    MS-Off Ver
    2016
    Posts
    201

    Drop down list gives data per year and month

    Hello,

    I was hoping someone can help me with my project.
    Can anyone teach me how to pull out data per month AND year depending on which drop down item is chosen?
    Same purpose of this is the pivot but hoping I can make it fancier by using drop down instead and a lookup value for the following criteria shown on the table.



    Here's the file
    Last edited by EXCELBENCH; 08-06-2018 at 02:15 PM.

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Drop down list gives data per year and month

    Is it what you 're looking for ??
    F6 to F17 = Month value
    G5 to J5 = Year to treat

    H6=SUMPRODUCT((Data!$A$1:$A$80='Historical Data'!$F$6)*(Data!$B$1:$B$80=$B$6)*(Data!D$1:D$80))

    Copy and paste as needed
    - Battle without fear gives no glory - Just try

  3. #3
    Forum Contributor
    Join Date
    03-23-2015
    Location
    Manila, Philippines
    MS-Off Ver
    2016
    Posts
    201

    Re: Drop down list gives data per year and month

    This is great! Thank you Sir!

  4. #4
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Drop down list gives data per year and month

    You are welcome, SUMPRODUCT is the typical function to replace Pivot Table
    Thx for the Rep

+ 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. [SOLVED] Count the times a month/year appear in a list of data
    By CliffyBiro in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-05-2018, 11:40 PM
  2. [SOLVED] Create a drop down for each month of th year
    By worthmw in forum Excel General
    Replies: 1
    Last Post: 09-29-2017, 11:20 PM
  3. How to display data based on a selected month from a drop-down list
    By Ahmed Ammar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-14-2014, 09:24 PM
  4. [SOLVED] Show data with month criteria drop list (dynamic)
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-16-2014, 12:54 PM
  5. Pulling data from list into month/year table
    By EC11 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-17-2013, 02:45 PM
  6. [SOLVED] how to return a day(number) by selecting month and year from data list
    By lizsantiago07 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-24-2012, 02:43 PM
  7. Drop days from dates to just month and year
    By mrrpv in forum Excel General
    Replies: 2
    Last Post: 02-01-2007, 12:49 PM

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