ROWS works but I want one less row result
You're welcome!
--
Biff
Microsoft Excel MVP
"Drew" wrote in message
...
Bill ... fantastic ... thanks heaps.
"T. Valko" wrote in message
...
I assume you're entering the formula in A13 and copying down:
=IF($A$12="","",IF(ROWS(A$12:A13)$F$2,"",$A$12))
--
Biff
Microsoft Excel MVP
"Drew" wrote in message
...
Hi All
Using the formula (excel 2007) below (thanks Max) I'm trying to
duplicate the contents of cell A12 (row 1 of my data) into the cells
below it for the number of rows corresponding to the value found in F2.
For instance F2 = 9 then once I enter any number into A12 I want that to
copy down another 8 rows.
The problem is that it copies one extra than I need. (because the
formula says to)
=IF(ROWS($1:1)$F$2,"",$A$12+ROWS($1:1)*0)
Adjustment appreciated. Thanks.
|