Hello,
I have a pivot table in Excel 2010. In the row label I have first Names, then audit period and for the value the average of their score. Because there will be multiple people entering data I have chosen approx. 1000 rows to populate in the pivot, so whenever someone enters data it will be consumed in the pivot.

The problem is that not only is the pivot taking the names I want it to, it's counting all the blank rows and giving them an average which is messing with my grand total average.

If I click on the filter in the name column and uncheck blanks, then add another row of data, refresh, the pivot refreshes but also makes the new data unchecked along with the blanks.

I have done a named range with this formula =OFFSET(Data!$A$2,0,0,COUNTA(Data!$A:$A)-COUNTA(Data!$A$1:$A$2),26) so when a name is entered and you refresh the pivot it populates. Which works, but I'd like to uncheck the blanks.

Please let me know if you can help, thank you