Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Line Chart with multiple series that have different date ranges | Charts and Charting in Excel | |||
Displaying date ranges for multiple years | Charts and Charting in Excel | |||
selecting different cell ranges across sheets, to display on summary page | Excel Discussion (Misc queries) | |||
Multiple Workbooks Summary | Excel Worksheet Functions | |||
summary by date | Excel Programming |