Extending formula series...

[Murilo]

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

 

[Pete_UK]

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