ROWS works but I want one less row result

D

Drew

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.
 
T

T. Valko

I assume you're entering the formula in A13 and copying down:

=IF($A$12="","",IF(ROWS(A$12:A13)>$F$2,"",$A$12))
 
D

Drew

Bill ... fantastic ... thanks heaps.

T. Valko said:
I assume you're entering the formula in A13 and copying down:

=IF($A$12="","",IF(ROWS(A$12:A13)>$F$2,"",$A$12))
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count help with numbering Rows? 2
#REF! error when copying formula beyond row 65536 in Excel 2007 1
Help on Macro to hide empty rows 4
After Macro runs, no cell activated - what am I missing? 2
Excel Help to copy information from one row at a time to another sheet 1
Automatically copy formulas in selected row into a new row? 3
Automatic delete row in Excel 2003 1
Duplicating Cell to another cell if it contains data 4

Top