Merge Many Calculated with airSlate SignNow

Consolidate record

hi and welcome to this tutorial here I'll show you how to take a range that has many values for the same product or person and consolidate that into one range without any duplicate values while at the same time summing the values for the same products or people from the first range so it sounds a little confusing I'll explain it in a second but if you'd like to get this workbook and download it go to teach Excel com search for this video tutorial and you can download this workbook and everything you see here so what I'm talking about is using the consolidate command in Excel and what I have here is a sample sales report I don't know it could be from a bunch of customers that's what we have here so customers on the left and amounts on the right and some of the customers have made multiple purchases throughout the month of September so we have John Doe for $34 right here John Doe 422 and John Doe for $14 so a big list of this is going to get kind of annoying and it'll be hard to see exactly how much John Doe spent total for the month and it is the same for Jim O'Leary so what we want to do is to be able to select this entire range and take out all the repeats so add up all of john doe's expenses for the month and just have one entry over here John Doe and then how much he spent so that's the goal of this tutorial and I'm going to show you how to do that with the consolidate command this is a great feature of Excel 2007 before I do that though make sure you have copied the headings to a new location so you can't bring the headings with you so new headings select where you want the consolidated data to go you have to do that before you consolidate then go to the data tab and select consolidate and if your Excel window is a little bit smaller than mine this may be a small bar but it's in the data tools window so go ahead and click consolidate and then a winner like this is going to open up so what we have here is the function that we would like to perform when we consolidate and most times it's the sum function you want to add everything together and in this case we want to add everything together we want to add john doe's expenses for the month together to create one number the next thing is the actual reference so where the data is that we would like to consolidate so I'm going to go ahead and select that right now when you've selected that go ahead and click this button again the next thing is to hit add and the reason it says all references here are because you can actually use...