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