G
gregmosu
I have two worksheets, one containing raw data, and the other a pivot
table averaging that data. In the first sheet, I have the candidates
name in order going down the rows(1-?), in the columns(A2-?), I have 20
questions w/their scores and at the end an average of those scores. The
problem is that not everyone has taken the test, and the average cell
only shows a divide by zero error(#DIV/0!). This is screwing up the
average display in the pivot table in the next worksheet. I was told
not to get rid of the candidates that have not taken the test, so how
do I get around this? Is there someting I can add to the pivot table so
that it ignors error rows?
Thanks,
Greg
table averaging that data. In the first sheet, I have the candidates
name in order going down the rows(1-?), in the columns(A2-?), I have 20
questions w/their scores and at the end an average of those scores. The
problem is that not everyone has taken the test, and the average cell
only shows a divide by zero error(#DIV/0!). This is screwing up the
average display in the pivot table in the next worksheet. I was told
not to get rid of the candidates that have not taken the test, so how
do I get around this? Is there someting I can add to the pivot table so
that it ignors error rows?
Thanks,
Greg