I Have a table like the attached images. I want to extract the latest "Project Starting date) subject to "Project Completed" and "Project Site.
"I want to know the latest project started date where the the project already completed in Dhaka.
I have tried with the following formula..
=MAX(IF(AND(Times!D3500=G1,Times!A3:A500=G2),Times!B3:B500))
But answer returning "0"
whereas the answer should be 12th May ..
Please help me friends...
"I want to know the latest project started date where the the project already completed in Dhaka.
I have tried with the following formula..
=MAX(IF(AND(Times!D3500=G1,Times!A3:A500=G2),Times!B3:B500))
But answer returning "0"
whereas the answer should be 12th May ..
Please help me friends...
