Help please, this is driving me mad!
Hi Steve,
Am Wed, 4 Oct 2017 11:07:19 -0700 (PDT) schrieb Steve:
What I mean is, a dropbox share invitation. I expect they come through as an email?
i sent you an email.
It is a little bit tricky.
Try in row 2:
=IF(SUMPRODUCT(--($A$2:$A$50=A2),--(MONTH($T$2:$T$50)=MONTH(T2)),--(DAY($T$2:$T$50)DAY(T2)-5),--(DAY($T$2:$T$50)<DAY(T2)+5))=4,0,1)
or
=IF(COUNTIF($A$2:$A$50,A2)/(MAX(IF($A$2:$A$50=A2,$T$2:$T$50))-MIN(IF($A$2:$A$50=A2,$T$2:$T$50))+1)=4,0,1)
The second formula must be inserted with CTRL+Shift+Enter.
Look which formula gives you the expected result.
Regards
Claus B.
--
Windows10
Office 2016
|