never really needed to use excel in the past, so apologies if this is a
dumb question.

let's say i have 4 sets of data. each set is 2 columns. 1st column is
a code, second is an occurrence count.

between the 4 sets, any particular code may or may not be in the data
set.

what i'd like to know is, is there a built in function that will align
all the codes and their counts for me?

i need to keep the individual data sets, so i can't just count up all
the individual codes and give the total. i've attached a couple samples
since this is kind of hard to explain. the first is the unsorted data,
the second is the desired output.

is there a built in function that will do this? if not, can anyone
point me in the right direction? i don't mind if this will take a bit
of work because it will save my group a LOT of time down the road.


+-------------------------------------------------------------------+
|Filename: test desired output.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=86|
+-------------------------------------------------------------------+

--
carl669
------------------------------------------------------------------------
carl669's Profile: http://www.thecodecage.com/forumz/member.php?userid=158
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=70423