| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic fill of columns
Greetings.
I'm trying to fill some cells horizontally with constants, and the number of filled cells depends of a specified value in another referenced cell. For instance, with A1=10, line 3 will have 10 horizontal cells filled from A3 to J3. This will be used to create a chart. I know I could create a simple formula in all of them with an =if(condition;1;) but this seems to me like a waste of cells with hidden functions. I would like to know if there is any other refined method for these cases or is this just a case of KISS? :) Thx. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drawing data from specific columns of a dynamic range | Setting up and Configuration of Excel | |||
| Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
| Fill Handle Across Columns | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| Dynamic charting problems (events) | Charts and Charting in Excel | |||
Linear Mode
