Hi all,

I am currently using the array formula to find out the most recent date a business as referred a deal. I have been using the below array formula to figure this out...

{=MAX(IF((Opps!A:A=[@Company])*(Opps!B:B=[@[Full Name]]),Opps!G:G,0))}

However, we have now have two types of deals. Opps and Suspects. SO now i need to figure out the most recent date from Opps!G:G and Suspects!G:G... regardless of what the deal type is. Hope that makes sense.

Basically i need to have a formula along the same lines as above but MAX date from if conditions from Opps OR conditions from Suspects

Thoughts?