Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have data on individuals who worked on a project. The table looks like:
Bob Mary Jon Steve Susan Tyler Project1 1 1 0 0 0 0 Project2 0 0 1 1 1 1 Project3 1 0 1 0 1 1 I want to create a matrix that tells me how many times each individual has worked with each other. So from the list above I would get Bob Mary Jon Steve Susan Tyler Bob X 1 1 0 1 1 Mary X X 0 0 0 0 Jon X X X 1 2 2 Steve X X X X 1 1 Susan X X X X X 2 Tyler X X X X X X The X's are actually a mirror image of the upper triangle. Is there an way to do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cross Reference between sheets | Excel Worksheet Functions | |||
Cross Reference | Excel Worksheet Functions | |||
creating an hourly matrix (scheduling) | Excel Worksheet Functions | |||
Creating a matrix from columns | Excel Discussion (Misc queries) | |||
How do I find a cross reference value | Excel Discussion (Misc queries) |