ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to calculate the difference of values (numbers) in a column? (https://www.excelbanter.com/excel-worksheet-functions/256632-how-calculate-difference-values-numbers-column.html)

Huseyin

how to calculate the difference of values (numbers) in a column?
 
A B C D
A1 10
A2 9 1
A3 8 2 1
A4 7 3 2
A5 6 4 3 1

I need to calculate the differences of each value in a column and have the
answers on second third column. For example subtract A2 from A1, A3 from A1,
A4 from A1, A5 from A1; and subtract A3 from A2, A4 from A2, A5 from A2;
subtract A4 from A3, A5 from A4; and finally subtract A5 from A4.

Any help is appreciated.


All times are GMT +1. The time now is 02:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com