ExcelAnalyzer highlights all Unique Formulas which allows the user to quickly see how the worksheet was built and makes it very simple to identify inconsistencies when formulas are different from each other.
In this example the green highlighted formulas in cells F7-G7 don’t add up all rows above and should be fixed.
ExcelAnalyzer’s Formula report lists all unique formulas and helps in detecting inconsistent formulas and it contains a link to easily navigate and correct the issues in formulas.
ExcelAnalyzer uses a colour-coding method to make each formula easier to read.
It’s about discovering the full DNA of the spreadsheet and checks: