Find formula that refer ahead of themselves

Find formula that refer ahead of themselves

Good spreadsheet practice suggests that spreadsheets should be built top to bottom and left to right, with calculation referencing following the same pattern i.e. always looking up or to the left to get information.

If a formula refers ahead of itself, it could indicate a problem, or perhaps it is why you have circular referencing.

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