View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
luvgreen luvgreen is offline
external usenet poster
 
Posts: 33
Default Is there a formula can get min value of a range by certain conditi

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!