Notifications
Clear all
Topic starter
Hi all
how can we get the max date based on the particular data, i have updated file for reference.
Posted : 19/12/2017 5:08 pm
Mohamed Saliha
Try this in cell H3
=MAX(IF(D8:D14=D3,E8:E14))
This is an array formula so press CTRL+SHIFT+ENTER instead of ENTER
Sunny
Posted : 10/12/2017 12:24 pm
Wow very nice & Thanks sunny, i have work for more than 5 hrs on this way, its is very simple formula which is you update
i am very thanks you.
Posted : 12/12/2017 1:48 am
