• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic cell reference in formula


New Member
I have a basic formula like G9-C17 but problem is the one of the reference cells is supposed to get changed everyday. In the row17, new column data will be appended everyday. Hence the formula would go on like G9-D17, G9-E17 and so on, changing daily. Any idea how make this dynamic reference?
P.S. I tried with Indirect but didn't seem to work


Excel Ninja
Please post out of your formula, and explain how do you want to make it as dynamic reference ?

Please also upload a sample file with around 10 lines raw data and the expected results

Last edited:

Peter Bartholomew

Well-Known Member
I tend to use a Table for input data. The structured reference that defines the table is dynamic.
= INDEX( Data, ROWS(Data), COLUMNS(Data) )
then references the final cell of the right-most column.