Hi Nitya,

Am Tue, 23 Jun 2015 02:06:05 -0700 (PDT) schrieb Nitya Satheesh:

Can I write if(C3=c2,if(b3-b2)<time(1,0,0),1,0),0)
Will this also work ?

please look here
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for the workbook "Events"
I highlighted one row yellow. IMO this event is a new event but only one
formula has 1 as result.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional