ExcelBanter - look up question

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - look up question (https://www.excelbanter.com/excel-discussion-misc-queries/259845-look-up-question.html)

look up question

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

Jacob Skaria

look up question

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

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

--
Jacob

"G" wrote:

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

All times are GMT +1. The time now is 11:14 PM.