ROWS works but I want one less row result
 

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.

ROWS works but I want one less row result
 

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.

ROWS works but I want one less row result
 

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.

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.