I am having trouble finding a formula that will sum data in 2 columns when the first column is sorted to UNIQUE values. I need to consolidate column A into unique values and SUM the values in column B and C for each unique values. Any thoughts?
I am having trouble finding a formula that will sum data in 2 columns when the first column is sorted to UNIQUE values. I need to consolidate column A into unique values and SUM the values in column B and C for each unique values. Any thoughts?
Hello & Welcome to the Forum,
Would a pivot table be an option for you?
If a pivot table is not what you are looking for, then maybe this sample will help.
Last edited by jeffreybrown; 11-26-2012 at 12:05 AM.
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks