Forum Discussion

Timothy Pautsch's avatar
Timothy Pautsch
Copper Contributor
May 09, 2018

Increase Cell Reference by 1 each day

Hello, I would like to automatically increase this formula each day from this:

 

=SLOPE(Data!C2:C14,Data!B2:B14)

 

to this:

 

=SLOPE(Data!C2:C15,Data!B2:B15)

 

to this, etc:

 

=SLOPE(Data!C2:C16,Data!B2:B16)

 

Essentially I want to expand the data set each calendar day as I enter new data. This will calculate a new slope each day which ultimately changes a future date that I am looking for. I'm tracking weight change and looking for an X-value that matches some Y-value i.e when Y=170, X=?. Any ideas? Thanks!

 

 

excel

2 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    May 09, 2018

    Hi Timothy,

     

    You have an option to create a https://support.office.com/en-us/article/Create-or-delete-an-Excel-table-e81aa349-b006-4f8a-9806-5af9df0ac664 from your existing data so that any formula referred to a column of this table will expand automatically if you add a new record.

     

    Please open the attached file and select cell C14, then press Tab to add a new record, and see how the formula will expand.

     

    Hope that makes sense

    Haytham

Resources