Good afternoon all,
I am trying the following formula to return the maximum/latest date from a table based on 2 criterias:
{=MAX(IF(AND('Completed Runs'!$F$4:$F$5000=R5,'Completed Runs'!$B$4:$B$5000="Outlook Plumbing"),'Completed Runs'!$H$4:$H$5000))}
However, it returns 0
Column B = Company Name
Column F = Zones
Column H = Dates of service
R5 = Zone (criteria)
So for this I would like to find what the last service date for company "Outlook Plumbing" in zone 1, was.
Thank you.
Marianne
Bookmarks