Hi, hope someone can help.
I have the following data in columns A and B:
John Project A
John Project B
Fred Project A
Fred Project C
etc
what I would like to do is create a matrix that looks like this:
Project A Project B Project C etc
John yes yes
Fred yes yes
etc
Is there a formula I can put in in order to egnerate the "yeses"?
thanks very much in advance
Terry
==
Terry Freedman
For articles on e-learning and ICT, and to subscribe to Computers in Classrooms, visit
http://www.ictineducation.org