I will enter a small WS with data on 2 NFL teams TAM or Tampa Bay and NOR or New Orleans. (columns A and Z)
There is a small data table underneath that begins on row 16. I would like to know if I were to insert the Indirect Function in front of my formulas in the data table if it would then allow me to add and subtract columns to the data above and maintain the integrity of the data table below.
I was somewhat confused by the use of the Indirect Function in the video based on mileage between cities in England and how the Indirect Function was the resolution to that table recognizing the correct cities. I'm thinking that the Indirect Function will allow me to move cells and still have Excel be able to direct the formulas to the correct cells.
Will this be the case or am I missing the use of the Indirect Function?
My second question is will the movement of the data table. or any function for that matter, cause Excel to change the range that the formulas are acting on. I've found that the row number can inexplicably change when I move the data tables around on the WS, usually shrinking the target range say from (A3: A50) to A3:A49) or (A3:A50) to A4:A50)