Hi everybody !!

i come again here with a problem i can seem to solve :s
i hope someone will be able to give me a hand on this...

here it is :

i have a sheet with 2 rows: location and activity.
several activities can be found in one location, even several of the
same activities.

schematic exemple
location activity
1 A
1 B
2 A
3 A
3 B
3 C
4 B
4 C


I would like to create something that give me as a result a sheet where
we can see the spatial relations between the activities.
so i would have all the activities in the fields and as much record as
i have activities too.
and in the record i would count how many time the two activities are in
a same place
the result would be something like :

X A B C
A 0 2 1
B 2 0 2
C 1 2 0

to give you idea, i've got over 3000 location and 250 activity...

does anyone have a nice little idea ? :d

tx a lot !!


--
qhorse
------------------------------------------------------------------------
qhorse's Profile: http://www.excelforum.com/member.php...o&userid=25807
View this thread: http://www.excelforum.com/showthread...hreadid=478171