View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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