In my previous blog post I complained that the Excel 2013 INQUIRE addin showed every single formula in A1 style, which is useless for recognising blocks of identical formulas.
So I’ve now done something about that – I am making available for free IQHelper, an Excel addin that further processes the Inquire Workbook Analysis Report, adds a column to the formula listing sheets showing the formula in R1C1 style, and then sorts and groups by that in order to bring identical formulas together. It also makes the Summary sheet hyperlinked.
The VBA code is unprotected so you can improve on it if you wish – if so, please tell me how it can be improved!
Download from http://www.sysmod.com/IQHelper2.xlam