Excel help

RickC Sniper · 09-22-08, 04:10 PM

I know absolutly nothing about MS Excel so I need a little help.

I intend to add hundreds of numbers to column A.
I need Column B to to tell me the difference between the adjoining numbers next to it in column A.

Example:
the formula for B5 is =sum(a5-a4)
the formula for B6 is =sum(a6-a5)
etc etc

I will be adding hundreds of numbers to column A and resorting in ascending order, lowest to highest.

How can I get column B to update automatically after sorting column A WITHOUT having to type in the formula for each individual cell all the way down column B.

This is Excel 2003.

.......thanks sooooooo much if you know a way for excel to "intelligently" complete column B.

09-22-08, 04:10 PM	#1
RickC Sniper Undetectable Join Date: Sep 1999 Location: Colorado Posts: 1,221 Downloads: 132 Uploads: 0	Excel help I know absolutly nothing about MS Excel so I need a little help. I intend to add hundreds of numbers to column A. I need Column B to to tell me the difference between the adjoining numbers next to it in column A. Example: the formula for B5 is =sum(a5-a4) the formula for B6 is =sum(a6-a5) etc etc I will be adding hundreds of numbers to column A and resorting in ascending order, lowest to highest. How can I get column B to update automatically after sorting column A WITHOUT having to type in the formula for each individual cell all the way down column B. This is Excel 2003. .......thanks sooooooo much if you know a way for excel to "intelligently" complete column B. __________________ Support Subsim http://www.subsim.com/store.html