I have a report of phone calls listing Caller Name (column A), Call Start DateTime (column B), and Call End DateTime (column C). There is no other data available. The report is currently sorted by A (asc), B (asc), C (asc). These reports often exceed 5000 rows of data.
I would like column D to be populated with the total number of concurrent calls active at the time the call was placed (i.e. calls in progress, including the current call).
Example:
<table>
<tr><td>Caller Name</td><td>Call Start DateTime</td><td>Call End DateTime</td><td>Concurrent Calls at Start</td></tr><tr><td>Angela</td><td>2/1/2005 13:00</td><td>2/1/2005 17:00</td><td>2</td></tr><tr><td>Bob</td><td>2/1/2005 10:00</td><td>2/1/2005 12:00</td><td>1</td></tr><tr><td>Charlie</td><td>2/1/2005 11:00</td><td>2/1/2005 15:00</td><td>2</td></tr><tr><td>Diane</td><td>2/1/2005 14:00</td><td>2/1/2005 16:00</td><td>3</td></tr></table>
A formula (array formula?) solution is preferred over a VBA script.
Any help is appreciated!!!
-NTA
I would like column D to be populated with the total number of concurrent calls active at the time the call was placed (i.e. calls in progress, including the current call).
Example:
<table>
<tr><td>Caller Name</td><td>Call Start DateTime</td><td>Call End DateTime</td><td>Concurrent Calls at Start</td></tr><tr><td>Angela</td><td>2/1/2005 13:00</td><td>2/1/2005 17:00</td><td>2</td></tr><tr><td>Bob</td><td>2/1/2005 10:00</td><td>2/1/2005 12:00</td><td>1</td></tr><tr><td>Charlie</td><td>2/1/2005 11:00</td><td>2/1/2005 15:00</td><td>2</td></tr><tr><td>Diane</td><td>2/1/2005 14:00</td><td>2/1/2005 16:00</td><td>3</td></tr></table>
A formula (array formula?) solution is preferred over a VBA script.
Any help is appreciated!!!
-NTA