Is there any way to calculate the first and second differences of a column of numbers in Excel? My spreadsheet is not enormous but sufficiently large that typing in a formula in each row is not an appealing solution.
Does anyone have any ideas?
Edit to clarify what I mean by first and second differences...
The first differences of a column are the differences between each element and the preceding element. Second differences are the first differences of the first differences. So what I need to do is put in, say, C2, the difference between B1 and B2, C3 the difference between B2 and B3, and so on for about 40,000 rows.