| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 : How to get the difference in a block of data ?
Dear Sir,
I have the following worksheet data: A B C D Vehicle Speedometer Mileage 1 BBN2361 9650 2 BBN2361 10600 3 BBN2631 12800 xxxxx (+B3-B1) 4 BSK1400 8500 5 BSK1400 9320 6 BSK1400 10250 xxxxx (+B6-B4) 7 BGA2367 12500 8 BGA2367 14260 9 BGA2367 16850 xxxxx (+B9-B7) The mileage is calculated by getting the difference between the last and the first speedometer reading of the same verhicle. May I know if there is any formula that I can input at C1 and copy down to get straight annswer at C3, C6 and C9 ? Other cells in column C is left blank. Thanks Low -- A36B58K641 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent! Prob with Excel 2002 Template Wizard with Data Tracking ad | Excel Discussion (Misc queries) | |||
| Excel 2002 - ReFormat DATA | Excel Discussion (Misc queries) | |||
| Want to Create a List in Excel 2002; Don't see List in Data Menu? | Excel Discussion (Misc queries) | |||
| Excel 2002: Excel cannot paste the data | Charts and Charting in Excel | |||
| Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
Threaded Mode
