Highest simultaneous occurence at a time

[Arjen Bakker]

Dear all,

I would need a formula which gives the highest simultaneous
occurence. In this simplyfied example it would 2 for "A" and
1 for "B"
Seems easy but I don't grasp it.

Thanks very much ... Arjen


[TABLE="width: 150"]
<colgroup><col width="64" style="width: 48pt;"> <col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;"> <col width="64" style="width: 48pt;"> <tbody>[TR]
[TD="width: 64, bgcolor: transparent"]A
[/TD]
[TD="width: 72, bgcolor: transparent"]14:00[/TD]
[TD="width: 64, bgcolor: transparent"]15:30[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A
[/TD]
[TD="bgcolor: transparent"]15:30[/TD]
[TD="bgcolor: transparent"]17:30[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A
[/TD]
[TD="bgcolor: transparent"]14:30[/TD]
[TD="bgcolor: transparent"]18:30[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 150"]
<colgroup><col width="64" style="width: 48pt;"> <col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;"> <col width="64" style="width: 48pt;"> <tbody>[TR]
[TD="width: 64, bgcolor: transparent"]B
[/TD]
[TD="width: 72, bgcolor: transparent"]14:00
[/TD]
[TD="width: 64, bgcolor: transparent"]15:30[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]B
[/TD]
[TD="bgcolor: transparent"]18:30
[/TD]
[TD="bgcolor: transparent"]20:30
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]




[/TD]
[/TR]
</tbody>[/TABLE]