Preventing event clustering

[Chris88]

Hi,
I want to exclude event overlaps in my dataset, i.e. all those events that appear within a 10 days time frame. I have started to convert the dates of events into numeric values so that they are more easy to identify.

I now have a single column range with these numeric values and want to identify all values for which the difference between any of these numbers is less than 10. For instance...

65
56
78
43
45
46
64

How do I do that?


best,

Chris

[Cheeky Charlie]

I would leave dates as dates if I were you - they are numbers too...
Are you leaving these dates unsorted?

Put this in B1 and copy down (or adjust as apt)

=IF(SUMPRODUCT(-($A$1:$A$7<A1+9),-($A$1:$A$7>A1-9))>1,"cluster","")

HTH