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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Formula Help 2
formula question 6
Help with a formula 7
IF(AND condition 1
compare 2 columns and select the lowest 2
Average if questions 2
Need formula to add cells with same group 1

Back
Top