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

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)?


--
Brile

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

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

"Brile" wrote:

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)?


--
Brile