excelexcel-formula

Add calculated count value to a formula which act as cell reference no

I have some range of data in F5:F25 , and this data can be appended on a daily basis, which can make them f5:30 on next day.

Instead of daily selected the range, I am counting the rows, says 25 as output.

Now I need to put this 25 in F5:F(25) here.

Doing it by f5:f& (cell reference where 25 is calculated) but I'm getting a name error

Solution

  • I think u r looking for

    =INDIRECT("F5:F"&ROW())

    please confirm if that is the case..

    idea : use INDIRECT() + row() that changes the formula reference at every row.