Test the unique formula in Excel

Test the unique formula in Excel

When Spreadsheet Professional runs the tests it must decide whether to run the tests on every single cell, or only on the unique formula cells (the F’s in the maps).

We prefer that it runs on every cell as it reduces the risk of us forgetting to check whether the copies are also wrong.

Note: if you have stumbled onto this page it would be best if you started at the beginning

Below a video clip explaining what this test in Spreadsheet Professional means

 

Purchase Spreadsheet Professional

 

Back to: Auditing an Excel spreadsheet > Prioritise which formula to look in for errors