+ Reply to Thread
Results 1 to 7 of 7

Sort and tally Multiple Entries

  1. #1
    Registered User
    Join Date
    11-20-2019
    Location
    Enumclaw, WA
    MS-Off Ver
    2013
    Posts
    3

    Sort and tally Multiple Entries

    Hey Everyone,

    I'm pretty new to macros and I need to tally recurring entries from a Paypal export by the name to new column for a mail merge for end-of-year donation receipt.

    Most donors give a monthly amount and I want to be able to give a total amount in the letter. So the new columns would have the unique name and the total amount of donations by that person.

    Any help is much appreciated!
    Attached Files Attached Files

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Sort and tally Multiple Entries

    .
    This is one method :
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Sort and tally Multiple Entries

    Not really sure how you want it, so only my guess...

    C1: enter formula
    =IF(COUNTIF(A$1:A1,A1)=1,SUMIF(A:A,A1,B:B),"")

    then copy down...

  4. #4
    Registered User
    Join Date
    11-20-2019
    Location
    Enumclaw, WA
    MS-Off Ver
    2013
    Posts
    3

    Re: Sort and tally Multiple Entries

    Thank You!

    That solves the amount is there a similar formula to isolate the name so when I do the mail merge not every line gets an entry?

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Sort and tally Multiple Entries

    A formula that will produce a list of distinct names is:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  6. #6
    Registered User
    Join Date
    11-20-2019
    Location
    Enumclaw, WA
    MS-Off Ver
    2013
    Posts
    3

    Re: Sort and tally Multiple Entries

    I'm not sure I understand. When I paste the formula anywhere in the C column I get the content in A1. I'm looking to get one donor and the total amount they donated . So I need to get A1-A9 which are all the same donor into one cell next to a cell that totals B1-B9. The spread sheet is has a few thousand entries

    Do I need to adjust this for each cell or Am I missing something?

    Thanks

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Sort and tally Multiple Entries

    I was using the file attached to Logit's post (#2) and putting the formula into cell F2 then dragging the fill handle down.
    If you want to use the formula in column C then F$1:F1 will need to reference the cell that is above the first cell containing the formula.
    For example if the formula is pasted into cell C2 the formula should read: =IFERROR(IF(MATCH(0,INDEX(COUNTIF(C$1:C1,A$2:A$100),,),)>COUNTA(A$2:A$100),"",INDEX(A$2:A$100,MATCH(0,INDEX(COUNTIF(C$1:C1,A$2:A$100),,),))),"")
    Let us know if you have any questions.

+ 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] Sort and tally bill of materials
    By ArtZ in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-18-2015, 06:56 PM
  2. [SOLVED] Formula if possible for sorting numbers into tallys
    By StuintheUK in forum Excel General
    Replies: 4
    Last Post: 07-15-2014, 05:48 AM
  3. Sort and Rank teams Win Loss Draw Tally in round robin tournament
    By jammjamm in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-07-2012, 06:19 PM
  4. sort field number to corosponding tally in a different xls name
    By jafooli in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2012, 11:36 AM
  5. create tally sheet for positions- insert names and tally #
    By tally sheets in forum Excel General
    Replies: 0
    Last Post: 04-11-2006, 04:45 PM
  6. [SOLVED] sort and tally routine
    By alvin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-04-2005, 09:05 AM
  7. Need help with yes/no and tallys
    By Steve H in forum Excel General
    Replies: 3
    Last Post: 07-26-2005, 08:05 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