On 31/05/2013 at 22:10, Johnny Rosenberg gurus.knu...@gmail.com wrote:
I obviously misunderstood the whole concept, so how is it supposed to be
done?
Like that:
{=MAX((C1:C1=P3)*(YEAR(D1:D1)=YEAR(TODAY()))*E1:E1)}
(C1:C1=P3) will act like IF statement. It will return 1
2013/6/1 Mirosław Zalewski mini...@poczta.onet.pl:
On 31/05/2013 at 22:10, Johnny Rosenberg gurus.knu...@gmail.com wrote:
I obviously misunderstood the whole concept, so how is it supposed to be
done?
Like that:
{=MAX((C1:C1=P3)*(YEAR(D1:D1)=YEAR(TODAY()))*E1:E1)}