look up question

  • Thread starter Thread starter G
  • Start date Start date
G

G

Hi , I have 2 columns - column A containes dates , coumn B contains
activieties ( meetings , phone calls , emails ) ..
I'd like to have a formula that returns the last date a meeting occured

Thanks
G
 
Try the below; and format the formula cell to date..

=SUMPRODUCT(MAX((B1:B100="Meeting")*A1:A100))
 
Back
Top