Return MAX() date in a list with a filter

**Flyinace2000** · 12-07-2012, 09:59 AM

I have a list of projects and funding requests. Some of the requests are appoved and others are not. I want to build a overview of the end date of the current approved funding and the end date of the funding that is in the pipeline.

Example attached.Latest Dates.xlsx

**Pepe Le Mokko** · 12-07-2012, 10:05 AM

Is the attached sthg you can live with ? Copy of Latest Dates.xlsx

**martindwilson** · 12-07-2012, 10:11 AM

in b12
=IF(MAX(IF(($B$3:$B$8=$A12)*($C$3:$C$8="yes"),$D$3:$D$8))=0,"",MAX(IF(($B$3:$B$8=$A12)*($C$3:$C$8="yes"),$D$3:$D$8)))
and in c12
=IF(MAX(IF(($B$3:$B$8=$A12)*($C$3:$C$8="no"),$D$3:$D$8))=0,"",MAX(IF(($B$3:$B$8=$A12)*($C$3:$C$8="no"),$D$3:$D$8)))
array entered then filled down