I've put together an algorithm to compare students' responses (i.e. compare
one students' responses against all other students). The workbook accomodates
8 individual multiple choice test worksheets +8 individual multiple choice
scoring worksheets +8 individual multiple choice grading worksheets [+ 8
Short Answer sheets in the same breakdown]. My problem is that even though I
can get the code to work, after I copy the algorithm into four or five sheets
the file gets so big that my Dell Vostro (2.2 GHz w/ 4 GB RAM) fails and
excel crashes. I'm basically writing an if statement: IF(cell=other cell,1,0)
but duplicated 100 times (for 100 multiple choice questions) and for 30
students against 30 students X 12 classes: 100X30X30X12 - it's big on one
worksheet; then I try to copy it onto 8 more. The objective here is to
determine whether students are copying off each other...