I have a large spread sheet with over 6000 product lines. I've attached a sample of data.
I need to group products together so that I can see the total number of products and value according to the type of product involved.
Eg on the sample spreadsheet I want the spread sheet to show the total number of "3003" products and "1002" products (with the option to then breakdown the total number into inidividual lines as per the current spreadsheet). As you can see from the sample - I've manually entered the totals i need to see in columns J & K.
I seem to think I can use "Groups" to do this but it's not something I've ever used so am looking for the easiest way to do this. If a simple formula can do the job then again that would be great.
If you can provide any suggestions in "an idiot's guide" format it would be appreciated.
Bookmarks