LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MZ MZ is offline
external usenet poster
 
Posts: 4
Default Two question about Excel 2007

Hello!

I have two questions:

I have such data:

A B
1 Date Weight (kg)
2 2008-02-27 103,5
3 2008-02-28 103,2
4 2008-02-29 103,0
5 2008-03-01 102,7
6 2008-03-02 not filled yet
7 2008-03-03 not filled yet
8 2008-03-04 not filled yet
etc. etc.

1)
How to get value of the last record entered. I mean:
how to get value of the first day entered in February 2008 and last value
of the last day of February 2008. So it the minus would like this:
A B
1 Date (month) Difference (kg) = Lost kg
2 Feb 2008 0,5 (because it equals 103,5-103,0)
3 March 2008 0 (because it equals 102,7-102,7)
4 etc. etc.

So above data would show me how much weight I lost in each/every month,
beginning
from Feb 2008 and finishing on the last month of the date entered in the
spreadsheet.
2)
How to get value of the first and last record entered overall. I mean:
how to get value of the first day entered in the whole data and last value
of the last day entered in the whole data. So it would be like this:
A B C
1 Date From Date To Difference (kg) = Lost kg
2 2008-02-27 2008-03-01 0,8 kg (because it equals 103,5-102,7)

So above data would show me how much weight I lost since the beginning of
loosing weight, that is
from Feb 2008 and finishing on the last month of the date entered in the
spreadsheet.

Thank you in advance for help
I really apprieciate it
Marcin from Poland

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Macro question Tangohammerli Excel Discussion (Misc queries) 0 February 23rd 08 03:38 AM
Excel 2007 Question Complibr Excel Discussion (Misc queries) 1 December 7th 07 12:12 AM
Excel 2007 PivotTable Question Dale Howard [MVP] Excel Worksheet Functions 3 August 28th 07 12:48 PM
Excel 2007 question? Dan the Man[_2_] Excel Worksheet Functions 4 July 8th 07 11:28 PM
Excel 2007 SmartArt Question [email protected] Excel Discussion (Misc queries) 0 June 8th 07 12:28 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"