I need an excel formula that will match cells in column A and for those that match add the values in column B together and then delete the duplicate rows with and just list 1 of each item with total v. I've taken a quick screenshot for this. I've selected my data (1). You won't find 'remove duplicates' in the Data menu (from the menu bar). Instead, click Data from the ribbon (2); click Remove Duplicates (3); confirm (4). If you don't see the 'Data' option on the ribbon, then look on the far right of the green ribbon for the cog symbol. Click that, then 'Ribbon Preferences'. Then you'll get to a customisation page where you can toggle the visibility of different ribbon groups. Hope this solves it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2019
Categories |