Hi all,
I have a table of customer who are awaiting or have had a procedure in a table like this:
<tbody>
</tbody>
These procedures should be done within six weeks but can take longer. What I'm wanting to be able to see is by procedure how many customers were waiting at each week by how many weeks they have been waiting. E.g.
<tbody>
</tbody>
I have about 120k rows with a variety of 20 procedures. I'm happy to use VBA or formula, and can add additional columns the the table if needed.
I have a table of customer who are awaiting or have had a procedure in a table like this:
| Customer ID | Procedure | Request Date | Completion Date |
| 0001 | Echo | 2018-04-02 | 2018-05-05 |
| 0002 | Echo | 2018-05-06 | 2018-05-27 |
| 0003 | TILT | 2018-05-07 | 2018-05-20 |
| 0004 | Echo | 2018-05-19 |
<tbody>
</tbody>
These procedures should be done within six weeks but can take longer. What I'm wanting to be able to see is by procedure how many customers were waiting at each week by how many weeks they have been waiting. E.g.
| Echo | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 |
| 02/04/18 | 1 | |||||
| 09/04/18 | 1 | |||||
| 16/04/18 | 1 | |||||
| 23/04/18 | 1 | |||||
| 30/04/18 | 1 | 1 | ||||
| 07/05/18 | 1 | |||||
| 14/05/18 | 1 | |||||
| 21/05/18 | 1 | |||||
| 28/05/18 | 1 |
<tbody>
</tbody>
I have about 120k rows with a variety of 20 procedures. I'm happy to use VBA or formula, and can add additional columns the the table if needed.
