DfE Tables Checking Exercise- 27th September 2018

Subject Progress 8 scores will report as NaN or -∞ until we have the average national entries in EBacc and Open baskets, which the DfE had indicated would be published in October. We are following this up with them directly. 

If you do not receive email confirmation that you have successfully submitted a ticket, please check your junk/spam folder. Please also check this folder if you don't appear to have received a response from us within 3 working days.


 Exported spreadsheet COUNTA formula is not working as expected

Solution

This is a common problem with Excel. The blank cells in the export are actually set to ‘Null’ instead of blank, which is why they are being included in the COUNTA.

There is another formula that you can use, which we’ve tested, and it seems to be more accurate:

=COUNTIF(range,"?*")

As of February 2017, Results Overview is the only export which 'auto-converts' NULL values to blank.

 

 
Was this article helpful? yes / no
 

 
Powered by Help Desk Software HESK, in partnership with SysAid Technologies