find latest date for 2nd, 3rd value

[koi]

Hi All,

can anyone advice how to find latest date as per my example? this is basically is almost the same with find 2nd, 3rd value using lookup in chandoo example but i need to find more answer especially if not using helper column.

i attached file for example and i already has the solution of my own but just curious if anyone can come up with different solution

Thanks in advance.

 

[Debraj]

In B2 use formula as..

=LOOKUP(2,1/(C2:Q2="yes"),$C$1:$Q$1)

 

[Somendra Misra]

Hi,

Another solution can be array formula use in B2 and copy down:

=LARGE(IF(C2:Q2="Yes",$C$1:$Q$1),1)

ENter with Ctrl+Shift+Enter.

Regards,

 

[koi]

hi Debra & Somendra,

thanks for the solution, it worked