| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating the difference between cell values in different rows - Loop
To All,
I have a list of data in column A: Eg: 1 2 3 4 5 5 I wish to calculate the difference between rows, i.e. ( 2-1), (3-2) etc, and be able to loop this for however many rows of data I have - which will vary. I then want to output the ranges to a sheet called sheet1. Any help would be much appreciated. Thanks in advance. Regards Joseph Crabtree |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I loop through a the values in multiple rows | Excel Discussion (Misc queries) | |||
| Calculating different values and percentages in rows | Excel Worksheet Functions | |||
| summing difference cell values across worksheets | Excel Worksheet Functions | |||
| SUMPRODUCT calculating difference between column values | Excel Worksheet Functions | |||
| error calculating negativ difference time values | Excel Programming | |||
Threaded Mode
