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: 4
Default Summary of Multiple Date Ranges

I have 5 worksheet tabs within the same spreadsheet. Each
tab has two columns with a beginning date (col A) and
ending date (col B). I.e.

Beg Date End Date Amt
11/24/03 1/14/04 $100
1/15/04 7/14/04 $150

etc.

The beginning and end dates are not the same for each tab.

I would like to create a summary that goes through all the
beginning dates and identifies the smallest date, the next
smallest date etc. to create one summary of all the dates.

MIN and MINA indentify the first smallest date, however, I
am unable to identify the next smallest date.

Is this possible? Thank you.
 
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
Line Chart with multiple series that have different date ranges Rach7110 Charts and Charting in Excel 2 April 26th 23 03:46 AM
Displaying date ranges for multiple years Jonathan Koehler Charts and Charting in Excel 1 August 24th 07 12:33 AM
selecting different cell ranges across sheets, to display on summary page NetMax Excel Discussion (Misc queries) 4 January 17th 06 07:42 PM
Multiple Workbooks Summary tcgaines Excel Worksheet Functions 0 December 13th 05 05:31 PM
summary by date BULEMOON Excel Programming 3 December 28th 03 11:33 AM


All times are GMT +1. The time now is 08:19 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"