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.