Hi, if anyone can help that would be great...example attached. 3 sheets with different data. Some of the names/initials across the 3 sheets are the same, some unique. I need to combine all 3 sheets into one set of data that aggregates the 3 sets of numbers but also recognises the different initials but groups the ones that are the same? So I have a master list of all unique initials with the corresponding aggregated data. Hope that makes sense. thanks in anticipation.
i would just copy the first 3 sheets of datas column A data to your combined tab.
Then highlight column A on your COMBINED tab. Go to DATA Ribbon at top of screen. Select REMOVE Duplicates. Then hit ok.
This will get you a unique master list. Then put the following formula in cell A2 and drag down:
Formula:
=IFERROR(SUMIF(Sheet1!$A$2:$A$50,COMBINED!A2,Sheet1!$B$2:$B$50),0)+IFERROR(SUMIF('Sheet1 (2)'!$A$2:$A$50,COMBINED!A2,'Sheet1 (2)'!$B$2:$B$50),0)+IFERROR(SUMIF('Sheet1 (3)'!$A$2:$A$50,COMBINED!A2,'Sheet1 (3)'!$B$2:$B$50),0)
<----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks