"Tell" Excel to start using a formula from rowX and end at rowX?

[Brile]

Hi,

how do I "tell" Excel if I have a formula in my Worksheet to start using the
formula from a certain row (and also end it at a certain row)?

 

[webtubbs]

You'll need to have the formula in all cells, but tell the formula to only
display a results in those rows you specify. For example, the below formula
will only show the results from the TODAY() function in rows between 5 and 20
(not inclusive)....

=IF(AND(ROW()>5, ROW()<20), TODAY(), "")

Wayne