luke

i modified the formula i dont know if it is right cause now it shows "0"
=SUMPRODUCT(C2:C100=D2)*(B2:B100+15)=MAX((C2:C100 =D2)*(B2:B100+15)-1)
--
Nisha P


"Luke M" wrote:

Assuming you input customer name into D2, this will give a count of how many
occurences of that name appear within 15 days of last entry:

=SUMPRODUCT(--(C2:C100=D2),--(B2:B100+15=MAX((C2:C100=D2)*(B2:B100))))-1


--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"nishkrish" wrote:

hi

i have a database where column b is date column c is customer name when i
input customer name in the system it should check if the same customer name
appears within 15 days of time from his last transaction.




--
Nisha P