I have two sets of data with some duplication between them and want to
combine the two to generate one report.

Eg
In Dept 1 they use Product 1, 2, and 4
In Dept 2 they use product 2, 3 and 4

I want to combine thes to show Depts 1 and 2's usage of all products. Can
it be done?

try using the Consolidate function in Excel
Post back if you need further assisatnce

HTH
--
If this posting was helpful, please click on the Yes button below

Thank You

cheers, francis









"Matthew G" wrote:

I have two sets of data with some duplication between them and want to
combine the two to generate one report.

Eg
In Dept 1 they use Product 1, 2, and 4
In Dept 2 they use product 2, 3 and 4

I want to combine thes to show Depts 1 and 2's usage of all products. Can
it be done?

I have tried the consolidate function but it consolidates the same row from
each sheet regardless of the product description.

"xlm" wrote:

try using the Consolidate function in Excel
Post back if you need further assisatnce

HTH
--
If this posting was helpful, please click on the Yes button below

Thank You

cheers, francis









"Matthew G" wrote:

I have two sets of data with some duplication between them and want to
combine the two to generate one report.

Eg
In Dept 1 they use Product 1, 2, and 4
In Dept 2 they use product 2, 3 and 4

I want to combine thes to show Depts 1 and 2's usage of all products. Can
it be done?

would you post your samples and the expected result.
or can you post your files to a free file hosting and let me know
where to pick it up.

I will see what I can do.

--
Appreciate that you click on the Yes button below if this posting was
helpful.

Thank You

cheers, francis









"Matthew G" wrote:

I have tried the consolidate function but it consolidates the same row from
each sheet regardless of the product description.

"xlm" wrote:

try using the Consolidate function in Excel
Post back if you need further assisatnce

HTH
--
If this posting was helpful, please click on the Yes button below

Thank You

cheers, francis









"Matthew G" wrote:

I have two sets of data with some duplication between them and want to
combine the two to generate one report.

Eg
In Dept 1 they use Product 1, 2, and 4
In Dept 2 they use product 2, 3 and 4

I want to combine thes to show Depts 1 and 2's usage of all products. Can
it be done?