How can I count deviations between two rows?
Hi Gary,
Am Sun, 30 Dec 2012 03:12:21 -0800 (PST) schrieb J. Gary Ellison:
1 Test Question 1 2 3 4 5 6 ...
2 Answers Key A C A B D B ... # of Right Answers
3 Student 1 A D A B D C ... 4 (Formula would go here to compare current row)
4 Student 2 A C A B D D ... 5 (with Answer Key row & count the right answers)
in H3 try:
=SUMPRODUCT(ISNUMBER(FIND({"A","C","A","B","D","B" },B3:G3))*1)
please suit the delimiter to your system
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|