I need to select last entry in a column, let say column G, then I am using this formula =INDEX(G:G,MAX((G:G<>"")*(ROW(G:G)))).
Now my columns can change depending on certain parameters, so I need to select column J instead. Now, how do I replace the part G:G with a dynamic formula which can fill other column names. So lets say in a certain cell (G20) I get the mentioned first cell in column J as $J$30, then I am using this formula to extract the column name =char(column(indirect(G20))+64) to get the alphabet J. When I use this formula in the above index formula, its not selecting the entire column J. Can someone guide me how to do this
Now my columns can change depending on certain parameters, so I need to select column J instead. Now, how do I replace the part G:G with a dynamic formula which can fill other column names. So lets say in a certain cell (G20) I get the mentioned first cell in column J as $J$30, then I am using this formula to extract the column name =char(column(indirect(G20))+64) to get the alphabet J. When I use this formula in the above index formula, its not selecting the entire column J. Can someone guide me how to do this