Страница 1 из 1

Combing Coinciding Results.

Добавлено: 23 авг 2009, 02:59
london735
Hello!
I wonder if it is possible to do the following with the help of the formulas alone. I have a list of events which START and END at different times. Some of them start when the other events are still in progress (their end date has not been reached yet). I need a way to combine the results of the events whose times overlap. The results of the overlapping events should be multiplied and stored as a single event. Any help will be hugely appreciated!
Thanks a lot!)

Re: Combing Coinciding Results.

Добавлено: 23 авг 2009, 04:20
EducatedFool

Re: Combing Coinciding Results.

Добавлено: 30 авг 2009, 22:26
london735
Hello! Many thanks for your help! Can you please help me to calculate the number of CONCURRENT events which correspond to each of the events which happens (I mean the number of events which occur AT THE SAME TIME). I need this number next to each of the events...Do you think it can be done by formulas alone?
Thank you again very much for your help!)