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
+-------------------------------------------------------------------
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
+-------------------------------------------------------------------