Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello All:
I want to know if I can use a formula to get the min date that task ID "A" and task type "STK"? Sample data below. I want to get 1/1/2005 as Min date for task A and Type STK. Thanks much!! Date Task ID Task Type 1/1/2006 A PR 3/1/2006 C STK 1/1/2005 A STK 1/1/2003 B PR 1/1/2006 A PR 1/1/2006 D PR 1/1/2006 E PR 2/1/2006 A STK Hope you all have a nice day! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Adjusting a formula cell range | Excel Discussion (Misc queries) | |||
Need formula to lookup a named range | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) |