Easiest to just illustrate what I'm trying to do:
So, For rows where the text in column A is identical,
Please Login or Register to view this content.
step 1 - sum up the their respective column B values
step 2 - write a single row with the text in column A, and the sum in column B.
All duplicate rows are deleted.
Any fast way to do this? I know about SUMIF but it's too many entries to do with multiple sumif's.
To get all unique entries, use advanced filters
as far as summig the data, try using sumif() =sumif(A:A,C1,B:B) assuming you extracted the unique entries to column C
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Nice FDibbins, it took a minute for me to figure out but once I did, it worked like a charm. Thanks very much.
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks