4Matrix 4Matrix Support Knowledgebase
Exporting Data
Suggested knowledgebase articles:

Knowledgebase Exporting Data

Articles in this category

How do I export data from 4Matrix?

Most tools in 4Matrix Desktop provide an Export function in the File menu, in the top left of the display. This will generally provide an .xls file of the data that you see on screen. It is also

2,311
(16)
Exported spreadsheet COUNTA formula is not working as expected

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 ca...

700
(25)
Numbers are formatted as text in the exported file

This is a known behavior and it's due to the numbers in 4Matrix being stored as a string. This is because we would generally hide or remove pupils from calculations when filters are applied in order t...

698
(15)
Share & Compare: Data Collaboration for Summer 2023

Updated: 24th October 2023 Our annual data collaboration exercise Share & Compare is back... For the latest S&C information, including publication dates and figures, visit https://www.4matrix....

353
(1)