Wouldn't you be better off using a pivot table?, the format you are
aiming for seems quite messy. How is the data collected?, what does it
denote - why the separate blocks of columns counting or recording the
same thing?

carl669;252167 Wrote:
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.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=70423