You’ve got the result of the summation of all the people in the list without any duplicate. Merging cells using keyboard shortcuts Select the cells you want to merge by dragging over the cells or click in the first cell and Shift-click in the last. Thus the formula in D2 will be applied in all the selected cells. 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.
Chapter 4: How to merge cells with the & operator.
Chapter 2: Grab your free exercise file here Chapter 3: Merging cells with the Merge & Center button.
Select Continue with the current selection and hit Remove Duplicates…Ĭheck My data has headers since Column C contain a header “Name”. Chapter 1: An introduction to Excel merging. 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. Now when you return to the spreadsheet, you.
In actual statistics, a person or an item could appear multiple times in the list with different values followed. When the Format Cells window appears, select the Alignment tab.