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

  • Thread starter Thread starter Brile
  • Start date Start date
B

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