Prev: Changing position of shapes in chart
Next: Ctrl+E to center
From: G on 25 Mar 2010 00:31
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
From: Jacob Skaria on 25 Mar 2010 00:55
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
 | 
Pages: 1
Prev: Changing position of shapes in chart
Next: Ctrl+E to center