LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default summary of values for a period of time

Hi,
is there some function or macro to do a summary of values, which were made
in a peoriod of dates? For example from this tab...

Value Date
5 1/1/2007
5 2/1/2007
5 3/1/2007
6 4/1/2007
6 5/1/2007
..
..
..
6 20/1/2007
9 21/1/2007
9 22/1/2007 etc...

this summary:

Value From TIll
5 1/1/2007 3/1/2007
6 4/1/2007 20/1/2007
9 21/1/2007 .....


Thanks a lot for advice

karmela
 
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
How to average values based on time period Peters48 Excel Worksheet Functions 6 January 9th 10 06:36 PM
Saving a file with time and date at a set time period Mark Dullingham Excel Programming 10 March 3rd 07 12:10 PM
average rate of change per given time period between 2 moments in time of a value David Virgil Hobbs Excel Worksheet Functions 1 December 19th 06 07:24 AM
average rate of change per given time period between 2 moments in time of a value David Virgil Hobbs Excel Programming 1 December 19th 06 07:24 AM
Every time i put a number with period it becomes a date and time excelSOS Excel Discussion (Misc queries) 7 March 7th 06 12:20 AM


All times are GMT +1. The time now is 04:37 PM.

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"