Create a log sheet of all array formulas in a workbook


There may be many array formulas in a workbook.  One may want to create a two column table in a sheet named “Array formula log” which lists down sheet names and cell address of all array formulas.  Furthermore, the cell references listed on the “Array formula log” sheet should be hyperlinked.

You may refer to my solution in this workbook.

Leave a Comment

Your email address will not be published.