Compacting or a Summation of several different lists into one
 

I have a master account sheet that lists orders and their contents. 10 orders
of up to 10 items currently but it could expand. The items could or could not
be replicated in each order. The problem lies in that I need to list all
items ordered in a summation list and that I cannot use VB.

Quantities and values can be done with a vlookup function but I'm scratching
my head over how to get the original list.

The sheet has sections like the following

order A
Item 3
Item 5
Item 7
Item 8

Order B
Item 5
Item 3
Item 1

Order C
Item 6
Item 5

Etc.

and a summation section that lists all those listed above: (the problem child)
Summation:

Item 1
Item 3
Item 5
Item 6
Item 7
Item 8


Would a set of arrays work?

--
-Richard

Compacting or a Summation of several different lists into one
 

Make a list of unique items and use the Sumif worksheet function

or

select your data and create a pivot table with the first column as the row
field. Unselect the Order entries in the dropdown list.

--
Regards,
Tom Ogilvy


"Richard" wrote:

I have a master account sheet that lists orders and their contents. 10 orders
of up to 10 items currently but it could expand. The items could or could not
be replicated in each order. The problem lies in that I need to list all
items ordered in a summation list and that I cannot use VB.

Quantities and values can be done with a vlookup function but I'm scratching
my head over how to get the original list.

The sheet has sections like the following

order A
Item 3
Item 5
Item 7
Item 8

Order B
Item 5
Item 3
Item 1

Order C
Item 6
Item 5

Etc.

and a summation section that lists all those listed above: (the problem child)
Summation:

Item 1
Item 3
Item 5
Item 6
Item 7
Item 8


Would a set of arrays work?

--
-Richard