LinkBack URL
About LinkBacks
Hi,
I'm looking for a VBA or a formula that could sum all the duplicate ID and go to the new sheet to paste unique ID and the sum of all the data. If you look at my spreadsheet, I want the result looks like in Sheet2.
Thanks,
Sum Duplicate Data.xlsx
Hi,
I'm looking for a VBA or a formula that could sum all the duplicate ID and go to the new sheet to paste unique ID and the sum of all the data. If you look at my spreadsheet, I want the result looks like in Sheet2.
Thanks,
Sum Duplicate Data.xlsx
tantcu,
Using your provided workbook, in 'Sheet2' cell C5 copied over and down:
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi Thank you for the reply. Sheet2 just the sample result I want to have. Imagine you don't have the unique ID in sheet2 to do SUMIFS just yet. How do you handle that issue when it could be thousands of data in sheet1
Use advanced filter to get the unique list
http://www.contextures.com/xladvfilter01.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks