I would like to use criteria 1 B$1:B$57=R2, and criteria 2 N$1:N$57=1 to return greater date but only if both citeria match. Otherwise, leave blank. I input the above formula as an array but it did not return what I thought it would. if n = .50 then it gives the greater date of the remaining cells. but I would like it to only return the greater date if B and R match and all n cells pertaining where they match have a 1.