Results 1 to 18 of 18

Summing up the largest terms per year in a dictionary

Threaded View

  1. #1
    Registered User
    Join Date
    03-22-2018
    Location
    Cologne, Germany
    MS-Off Ver
    2016
    Posts
    8

    Summing up the largest terms per year in a dictionary

    Hi VBA experts!

    I’m a vba greenhorn and got a –in my opinion- complex problem.

    First of all: I need a makro solution, even if the Pivot table does some of the following steps

    Now to the Problem:
    In one column i got some dates in the format DD.MM.JJJJ and in the other one some terms such as „screwdriver“, „tire“ ,... for example.

    I now need a vba code, that counts the frequency of terms per year and sum up the four largest ones for every year.

    With a little help i solved the first part of the problem by using a dictionary.
    So i got an output like this

    A / B / C
    2009/ screwdriver/ 4
    2009/Tire/ 3
    2009/ pencil / 7
    2009/ ball / 9
    2009/skateboard/2
    .
    .
    2010/tire/2
    ...


    In this example case there are 4+3+7+9+2=25 terms for 2009. The sum of the largest four is 9+7+4+3=23.

    And now I want an output like

    D / E
    2009/23

    How can sum up only a part of my dictionary?
    Maybe I need a complete different method?
    I hope you understand the problem and can help me to solve this!

    The attached file contains the data in Table1 and my Dictionary Output in Table2.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Summing Largest 50 values based on criteria
    By Scooby5 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 08-27-2014, 10:38 PM
  2. Summing largest value per individual
    By domnisignis18 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-22-2012, 12:10 PM
  3. Matching Dictionary Terms with Definitions
    By luu980 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-22-2009, 02:08 PM
  4. Matching Dictionary Terms with Definitions
    By luu980 in forum Excel General
    Replies: 2
    Last Post: 03-09-2009, 02:56 PM
  5. Matching Dictionary Terms with Definitions
    By luu980 in forum Access Tables & Databases
    Replies: 0
    Last Post: 03-09-2009, 12:45 PM
  6. [SOLVED] Create dictionary of terms, create first time user site
    By Solitaire Jane Austin in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-19-2006, 05:55 PM
  7. Summing the N Largest Values in a Range
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-28-2005, 11:18 AM

Tags for this Thread

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