Hi,

I have a spreadsheet looks like this:

QID C1 C2 C3 C4 %a %b %c %d
13123 b b b b 0 100% 0% 0%
13124 d d d d 0% 0% 0% 100%
13125 d d d d 0% 0% 0% 100%


QID is the question ID and C1 to C4 are the answers by students. Column "%a"
is the percentage of "a" answered by students. I use countif function to
calculate that.

Everytime I copy and paste a group of answers the number of questions (
number of rows) and number of answers (number of columns) will be different.
Is there any macro that will calculate (%a, %b, %c and %d) and insert the
result in the first empty column?

Hope this is clear enough. Any answer will be appreciated!!