precedents

Is it faster to have fewer dependencies and more columns or vice versa? Thanks

It's very useful to be able to press CTRL+[ in order to navigate to the first precedent/reference in a formula. (And then to press F5 to jump back to the formula.) However, what if a formula has multiple precendents/references, including some or all that appear on a different worksheet? It...

I'm working on updating a file from my work predecessor that has some external links. As I opened each external link, I find that each of those files have external links and this continues for about 5 levels deep. Is there a way or program that will map all the external links back to the...

Hi all, At my previous employer we had a tool/shortcut that allowed us to click on a cell containing a formula and then cycle through its precedents using shortcuts. The cycle was started off with CTRL+G (repurposed from Microsoft's default use) and then you could move to each precedent of the...

I require conditional formatting to apply a cell color, either red or green depending on whether it is greater than a critical value contained in an adjacent cell or less than or equal to that same value. The cell to be formatted displays the result of a calculation whose precedents are...

Hi everybody! First time poster, and VBA newbie here. I've been trawling the internet and racking my brains to try to solve my problem but haven't got anywhere, so thought I'd register on here to see if anyone can help... The issue I have is that I'm trying to analyse a formula and I want to...

Hi, I thought I’d share this to get your thoughts. I have only 2010 – does anyone get the same with 2007, 2013, 2016, etc.? Steps to reproduce: 1. Create a new workbook with at least two tabs. 2. On one tab make a table (ListObject) with headers and data a. In cells A1:A2 enter a label...

I want to locate the cell that a lookup function (VLOOKUP, HLOOKUP, or INDEX) gets its value from. For example: if Cell A2 = "lookup_ref" then VLOOKUP("lookup_ref",A1:D4,3,False) should return the value of cell C2. I need to be able to find out what the source cell (i.e. C2 in this...