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 solution without vba just a helper column
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.
b5=SUMPRODUCT((DayPlan=B3)*(MATCH(Codeplan&$B$11:$B$57,Codeplan&$B$11:$B$57,0)=ROW(Codeplan)-ROW(C11)+1)*(Qtyplan))
Try this and copy towards right
Please Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Thank you not only helping out with the formula but also for making it very easy to understand!Originally Posted by humdingaling
I was focusing too much on my table that I forgot about having a helper column!
Thank you! I will be studying up on your formula to be able to do these kinds of formulas on my own next time.b5=SUMPRODUCT((DayPlan=B3)*(MATCH(Codeplan&$B$11:$B$57,Codeplan&$B$11:$B$57,0)=ROW(Codeplan)-ROW(C11)+1)*(Qtyplan))
Try this and copy towards rightPlease Login or Register to view this content.
*added reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks