look up question

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
 
J

Jacob Skaria

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

Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
MS Project Overwrites Max. Resource hrs 0
Formula Help 2
Avoiding Leads, using SVT, and Linking Tasks correctly 0
Multiple Criteria Lookup Function 1
Help with a formula 7
Need formula to add cells with same group 2
Offset question 0

Top