Go to Data tab and click on the Consolidate icon. Now let's go back to our data and look at two more ways that are just as simple. Now you can say what rows you want to see here: the author's name is a key column in our example, and we need to take "Quantity" for our values to see the number of books you have by each author. Choose where you want to see the results and click ok. Open the Insert tab, click Pivot Table, and make sure the selected range contains all your data. Perhaps the best way to go is to add a pivot table. Let's count the number of books by different authors we have in this list. When you deal with numbers, Excel has ready solutions for you. Consolidate duplicates in excel and sum numbers You may have text values associated with the same record, or unique numbers that you want to count. In this video we will learn how to keep unique values when merging duplicate rows in Microsoft Excel. How to combine duplicate rows in Excel: video transcript
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |