Merge two lists for side by side comparison

  • Thread starter Thread starter mfrye
  • Start date Start date
M

mfrye

I have two lists I want to compare for quantity and cost. The lists ar
from two different sources. I want to sort both lists by identifier an
then merge the identifier column to give me side by side quantity an
cost data for each identifier.
Results have to be shown in the format of the combined list I've show
below
at the "request" of the auditors. I know there should be a simpl
solution but I'm frustrated and at a loss as to how to do this.
Please help

+-------------------------------------------------------------------
|Filename: sort match merge.jpg
|Download: http://www.excelforum.com/attachment.php?postid=2690
+-------------------------------------------------------------------
 
Hi!

Better if you give us a flavour of the existing data; the fina
structure you want; whether the two sets of identifiers are the same o
mutually exclusive or overlapping.


Al
 
Back
Top