+ Reply to Thread
Results 1 to 5 of 5

formula look up deleting duplicates and tally

  1. #1
    Registered User
    Join Date
    08-19-2013
    Location
    rochester ny
    MS-Off Ver
    Excel 2003
    Posts
    3

    formula look up deleting duplicates and tally

    My apologizes if this is covered else where I did several searches but could not find a formula that worked for what I'm trying to do. I have a spreadsheet (tab 1) that is filled in via a form that teachers fill out on google docs. I am trying to add a tab 2 that will be an ongoing tally of student's merit/demerits from tab 1. I need help with a formula to use that will sort out students names so they are not duplicated and then tally their merits/demerits. Any help would be greatly appreciated!!
    Attached Files Attached Files

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: formula look up deleting duplicates and tally

    You could use advanced filter to get the unique names:

    http://contextures.com/xladvfilter01.html#FilterUR

    Then you can use VLOOKUP to get the IDs and SUMIF to get the merits/demerits.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    08-19-2013
    Location
    rochester ny
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: formula look up deleting duplicates and tally

    Thanks Tony!!! I now have the names sorted with no duplicates (tab 2). I am still having trouble with getting the merits calculated correctly using SUMIF also tried DSUM with no luck. Any help would be greatly appreciated!
    Attached Files Attached Files

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: formula look up deleting duplicates and tally

    Hi ellen,

    How about looking at a Pivot Table solution? See attached.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  5. #5
    Registered User
    Join Date
    08-19-2013
    Location
    rochester ny
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: formula look up deleting duplicates and tally

    That works perfect!!!! Thanks so much Marvin!

+ 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. deleting duplicates
    By crosset in forum Excel General
    Replies: 1
    Last Post: 06-02-2011, 07:48 PM
  2. Deleting Duplicates-find out a way to delete duplicates
    By sighlent1 in forum Excel General
    Replies: 2
    Last Post: 04-19-2011, 10:17 AM
  3. Deleting Duplicates
    By 3smees23 in forum Excel General
    Replies: 3
    Last Post: 05-07-2009, 10:48 AM
  4. 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
  5. Deleting duplicates
    By Judd Jones in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2005, 12:06 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