looking for a function that will filldown to the last cell.

the function has to take the first cell as a variable (range?) and fill from that cell till the last filled cell in a reference column for example

a formula that calculates something from cell a1, go through all the values in column A and apply the formula till aX.

the function has to take the first cell as a variable.