+ Reply to Thread
Results 1 to 5 of 5

Sum first instance of duplicates within a date range

  1. #1
    Registered User
    Join Date
    06-21-2017
    Location
    Bangkok, Thailand
    MS-Off Ver
    Excel 2010 (Professional)
    Posts
    3

    Sum first instance of duplicates within a date range

    I hope anyone can help with this.

    As per attached, I want to get the sum of first instance of duplicates in a range on the specified date (plan date)
    Ex: on 6/1 each first instance of Part Code and Order equals to 60 qty

    Please note that I am inexperienced with VBA but I welcome any solution for my problem.

    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Sum first instance of duplicates within a date range

    attached solution without vba just a helper column
    Attached Files Attached Files
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,511

    Re: Sum first instance of duplicates within a date range

    b5=SUMPRODUCT((DayPlan=B3)*(MATCH(Codeplan&$B$11:$B$57,Codeplan&$B$11:$B$57,0)=ROW(Codeplan)-ROW(C11)+1)*(Qtyplan))
    Please Login or Register  to view this content.
    Try this and copy towards right
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  4. #4
    Registered User
    Join Date
    06-21-2017
    Location
    Bangkok, Thailand
    MS-Off Ver
    Excel 2010 (Professional)
    Posts
    3

    Re: Sum first instance of duplicates within a date range

    Quote Originally Posted by humdingaling View Post
    attached solution without vba just a helper column
    Thank you not only helping out with the formula but also for making it very easy to understand!
    I was focusing too much on my table that I forgot about having a helper column!

  5. #5
    Registered User
    Join Date
    06-21-2017
    Location
    Bangkok, Thailand
    MS-Off Ver
    Excel 2010 (Professional)
    Posts
    3

    Re: Sum first instance of duplicates within a date range

    Quote Originally Posted by nflsales View Post
    b5=SUMPRODUCT((DayPlan=B3)*(MATCH(Codeplan&$B$11:$B$57,Codeplan&$B$11:$B$57,0)=ROW(Codeplan)-ROW(C11)+1)*(Qtyplan))
    Please Login or Register  to view this content.
    Try this and copy towards right
    Thank you! I will be studying up on your formula to be able to do these kinds of formulas on my own next time.
    *added reputation

+ 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 of Second Instance
    By cjamps in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-07-2016, 11:27 AM
  2. [SOLVED] Apply formatting to first instance of highest value wthin range (exclude duplicates)
    By nurseydiamond in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-07-2015, 11:05 AM
  3. [SOLVED] Add Duplicates and Save On Instance
    By hftechno in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-12-2014, 03:01 PM
  4. [SOLVED] Count duplicates and duplicates with suffix as one instance
    By ruraljur0r in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-24-2014, 12:38 AM
  5. Highlighting all duplicates except the last instance
    By bopsgtir in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2013, 06:57 PM
  6. highlight all duplicates EXCEPT first instance
    By Blake 7 in forum Excel General
    Replies: 7
    Last Post: 04-27-2012, 01:33 AM
  7. Replies: 6
    Last Post: 03-29-2012, 12:16 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