View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
webtubbs webtubbs is offline
external usenet poster
 
Posts: 1
Default "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