The example that you are giving now is nothing like the previous, and we all
worked to that. Originally you said =A30-A4, now you say =A5-A1. What
exactly do you want? Is it static, variable, what?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mworth01" wrote in
message ...

Thanks for all of the replies so far. Unfortunately, I haven't been
able to get any of them to work yet. Let me try a smaller example,
starting in A4. Column B is what the results should look like (30-5,
25-10, 20-15):

(Ignore the underlines...they are just there for formatting purposes)
Col. A____Col. B
5________25
10_______15
15_______5
20
25
30

Your ideas definitely introduced me to some new formulas, so I'm going
to try to modify your equations and see if I can't figure it out. I
may not have explained myself properly in my first post, so hopefully
having numbers will make it more clear. Again, the key is that I want
to be able to use the fill down feature to copy the formula in column B
for all of my data (I have over 2000 points that I need to apply this
formula to). In the equations that were suggested, the 34 in
=INDIRECT("A"&34-ROW())-A4 doesn't change so I'm always subtracting the
new row (A4, A5, etc.) from the data in A34. I need A34 to become A33,
A32, etc. Again, hopefully the numbers speak to where my words are
failing. Thanks so much for looking at this.


--
mworth01
------------------------------------------------------------------------
mworth01's Profile:
http://www.excelforum.com/member.php...fo&userid=8991
View this thread: http://www.excelforum.com/showthread...hreadid=535004