YOU ROCK!!
I finally got it to work!!
Two things:
1. When there are zero calls it's returning a 1/0/1900 date. I tried putting a ,""))} in the formula so it will just leave the cell blank, it still gives the same date.
My formula is:{=MIN(IF($B$4&$C$3=REGION1&SLA1,CONTACT_DATE1,""))}2. I'm automating this for VBA. Since this is an array formula (requires CTRL+SHIFT+ENTER), is there anything special I should do, or will it be ok when I record the macro?
I cannot thank you enough for your help!!!
Bookmarks