| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dragging formula works for columns but not rows? | Excel Discussion (Misc queries) | |||
| How do I get rid of blank rows between data and Ctrl End result? | Excel Discussion (Misc queries) | |||
| Offsetting the Rows of a VLookup Result | Excel Worksheet Functions | |||
| How do I convert works file to excel without works software? | Excel Discussion (Misc queries) | |||
| Put the result of the calculation between 2 columns in a new works | Excel Discussion (Misc queries) | |||
![Drew[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
