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

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
---
"RobFJ" wrote:
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

Take a look at these sites:
http://peltiertech.com/Excel/Pivots/pivottables.htm
http://www.babeled.com/2008/07/18/ex...-manipulation/

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Max" wrote:

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
---
"RobFJ" wrote:
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