Monday, June 19, 2006

Enter the Matrix

In order to try and keep all our teams organized, I use Excel like it was the end of the world. Here is a quick snippet.

Names go down the rows. Teams are across the top for columns. Two more columns include attending Mission Advance and whose car they are in. An x in the column for each student signifies who is going on what.

Way over on the right are summary tables using important function = COUNTIF(L2:L79,"x"). That counts the number of how many cells have 'x' within the range.

Click on the image for full size.

Technorati tags:: ,

No comments:

Post a Comment