Hi
use the following formula:
=OFFSET($A$1,0,ROW(1:1)-1)
and drag down
--
Regards
Frank Kabel
Frankfurt, Germany
"Doug" schrieb im Newsbeitrag
...
Hi. I guess this problem I have is what pivot tables might be for,
but I'm
hoping there's something easier to do when it's a somewhat small
amount of
data.
1. First problem:
I have data running left to right (A1, B1, C1, etc.) with a column
represeting each state. I want to drag a formula that is essentially
"=A1/1000" from the top of a new column down to the bottom with each
state's
data in row 1 being given this treatment. Natrually, the computer
reads this
and fills in A1/1000, A2/1000, A3/1000. I can write A$1/1000, but
then each
line just fills in with the result of A1/1000. How do I make the 1
stay the
same, but the Alpha part of the cell name change?
2. I also have data running top to bottom (A1, A2, A3, etc.) with a
row for
each state. Thus, there's a diagnol line of data from A1, B2, C3, D4,
etc.
where each state is represented in both the column and row. I need to
have a
column of data that sums the row (B1:B50), but substracts the
relevant cell
in the diagnol. In this case B2. Any thoughts?
Thanks.
-Doug Hess
|