Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extending formula series...
I am afraid I did not make
my question correctly, so let me rephrase it: When creating a new cell series, i.e., montlhy net profits from a company, where monthly gross profits are organized in a line and monthly taxes are organized in a column: After creating the formula, and let's suppose I want net profits arranged over a line: when "dragging" it to extend the results, Excel tend to extend the formula following the same "axis", that is, it goes horizontal, instead of vertical... I am now having to transpose the taxes column into a line to make it work, but was wondering if there would be a way to solve it without having to create this line that repeats the info shown in the column... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extending formula series...
You could build up the reference of the cell you want to get data from
as a string in your formula, making use of the row and column information of the cell the formula is in, and then incorporate the INDIRECT function to make Excel get the data from that calculated cell. Another approach would be to use the OFFSET function. If you were to give actual details of how your data is laid out and what formula you want to use, then I'm sure someone will be able to suggest an exact formula for you to use. Hope this helps. Pete On Jul 17, 11:07*pm, Murilo wrote: I am afraid I did not make my question correctly, so let me rephrase it: When creating a new cell series, i.e., montlhy net profits from a company, where monthly gross profits are organized in a line and monthly taxes are organized in a column: After creating the formula, and let's suppose I want net profits arranged over a line: when "dragging" it to extend the results, Excel tend to extend the formula following the same "axis", that is, it goes horizontal, instead of vertical... I am now having to transpose the taxes column into a line to make it work, but was wondering if there would be a way to solve it without having to create this line that repeats the info shown in the column... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Doubt on extending series. Someone could help?! | Excel Discussion (Misc queries) | |||
extending a horizontally calculated formula vertically | Excel Discussion (Misc queries) | |||
Extending Row() | Excel Worksheet Functions | |||
Extending a date series | Links and Linking in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |