| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find the earliest dates in a range of dates?
In order to do what I ask, I know that I am supposed to use the MIN
function, but there is a twist to what I want to do. I have a set of data where each row is coded with a number (01, 02, 03... 10, 11, 12, etc.). Each row has a date associated with it. I want to find out is the earliest start date of all the rows coded "01", the earliest start date of all the rows coded "02", etc. Does anyone know how this can be done? (NOTE: My "Code" column is column C and is named "Code". My "Dates" column is column H and is named "Dates".) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I select from within a range of dates? | Excel Discussion (Misc queries) | |||
| Formula to retrieve range of dates from a worksheet to calculate d | Excel Worksheet Functions | |||
| Find a "date" in a column of dates in Excel 2000 | Excel Worksheet Functions | |||
| find a cells from a range of cell | Excel Worksheet Functions | |||
| Use MATCH to find position of max in 2D range? | Excel Worksheet Functions | |||
Threaded Mode
