Need help to create cross Reference table/Matrix in Microsoft Excel

[Eas!war]

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.

[BillieJ]

All those Xs make it harder to read. I think I'd use conditional formatting to hide the Xs and then use a light gray fill. You could choose from several methods, but certainly the simplest is to apply on the basis of data from three fields (Name, Sex and Age) a PivotTable report.

[Gania]

Run, for example from the 2003 version, from the Data menu> Report Chart and PivotTable (PivotTable view number), we selected first (Step 1 of the wizard) that our range of data is in an Excel database , and we want only a PivotTable report. in step 2 of the wizard select the area $ A $ 1: $ C $ 11. Finally, mark a target cell, for example, on the same sheet, the cell E3. Now from the field list, we generate the pivot table structure, bringing the Age field to the column area, the Gender field to the row area and finally the Name field, for example, the data area. Probably doing it this way and we built the table we wanted.