Drag it to select all the cells in Column D (in my case it’s from D2 to D12). Then put the cursor at the lower right corner of D2 till it becomes a small black cross. You can adjust the formula to adapt your situation. To sum the values, double-click D2 and input the formula “ =SUMIF(A$2:A$14,C2,B$2:B$14)“, which refers to calculating the summation value of C2 according to the data in B$2:B$14 corresponding to the names in the range of A$2:A$14. Now the duplicates have been removed in Column C. Select Continue with the current selection and hit Remove Duplicates…Ĭheck My data has headers since Column C contain a header “Name”. Keep selecting the content in Column C and click Remove Duplicates in Data tab. You can do it by clicking the Column Header A, pressing Ctrl+C, and clicking Column Header C or the cell C1 then pressing Ctrl+V. First, copy the content in Column A to Column C.
I can remove one of them and calculate the summation directly but what if the list is much longer and the duplicates is a lot more? It’s apparently that there’re 2 person show up twice in the list. Instead, we need to combine these cells and sum their values. In actual statistics, a person or an item could appear multiple times in the list with different values followed.
0 kommentar(er)
