Creating Summary Worksheet

R

RobFJ

I've got an existing worksheet (items_sold) with 2 columns.

Column A has an item description (eg Item 1, Item 2, Item 3). The items are
repeated througout the list. Column B has the number sold of each item.

eg

Item 1 6
Item 2 12
Item 1 3
Item 3 3

I'd like to create a new worksheet where column A is a list of each item
that appears in items_sold (but with no repeats) and column B is the total
of items sold. eg

Item 1 9
Item 2 12
Item 3 3


Can SKS help


TIA


Rob
 
M

Max

A pivot is ideal for this. Assuming the 2 col headers are Name & Qty, just
create a pivot, placing Name into ROW, Qty into DATA area (it'll show as
Sum). Incredible, but that's it. Go to the pivot sheet, where you'll see the
exact results that you seek, ie the list of unique items, and the
corresponding sum of quantities next to it. Any good? ring the stars in
google.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Lookup 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Validation List 2
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1
Creating items list with corresponding prices 6
Formula, Macro, or VBA code to find and insert 3
comparing data in excel 3
Consolidate Lists from Multiple Sheets on another Sheet 9

Top