| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return a smallest date
Dear experts,
I've rows of records which column A is for dates and column E is for saleman's names: 1 Aug 2007 Tommy 15 Aug 2007 Tommy 26 Sep 2007 Tommy 4 July 2007 Peter 25 Sep 2007 Peter 18 Nov 2007 Peter Is there a function which can filter out the earliest date for Tommy, Peter....etc. Please advise. Thanks & regards. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
| formula to look up and return smallest date from a range of dates | Excel Worksheet Functions | |||
| Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
| Return the smallest value | Excel Worksheet Functions | |||
| calc constant date from variable date & return with ability to rn. | Excel Worksheet Functions | |||
Threaded Mode
