Forum Discussion
How to find the latest date based on criteria
Hi, Can someone please help me in developing a formula/pivot that allows me to find the latest date based on some criteria. Below is the example Excel that is similar to what I am using: F...
=LARGE(IF(($A$2:$A$11=E2)*($C$2:$C$11="Yes"),$B$2:$B$11),1)You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021.