"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
|