Greetings,
I have a file that uses entire columns in its lookup formulas.
Convenient but it renders the TracePrecedents almost useless.
I would like to find a cell's Precedents that are referenced directly by the cell address,
but ignore all references made via entire column parameters.
As an example, assume I want to trace all precedents to cell B1.
F1 contains "=vlookup("Total", $B:$C, 2, false)"
F2 contains "=B1*2"
Both F1 and F2 are Precedents, but
I see F2 as a valid Precedent, and F1 as an indirect Precedent.
Is there a way to remove the indirect Precedents from the Precedents collection?
Thanks,
Anil
Bookmarks