Hi,
I have a basic spreadsheet with 4 columns of data:
I want to run a macro/query that outputs the total numeric values for any given date.
e.g.
<colgroup><col><col span="2"><col></colgroup><tbody>
</tbody>
How could I do this?
Thanks.
I have a basic spreadsheet with 4 columns of data:
- Column A contains a date
- Column D contains a numeric value
I want to run a macro/query that outputs the total numeric values for any given date.
e.g.
Week Commencing | Name | Location | Days |
02 January 2017 | anonymous | London | 4 |
02 January 2017 | anonymous | London | 4 |
02 January 2017 | anonymous | London | 2 |
02 January 2017 | anonymous | London | 4 |
09 January 2017 | anonymous | London | 3 |
09 January 2017 | anonymous | London | 4 |
09 January 2017 | anonymous | London | 2 |
09 January 2017 | anonymous | London | 2 |
16 January 2017 | anonymous | London | 5 |
16 January 2017 | anonymous | London | 2 |
16 January 2017 | anonymous | London | 5 |
16 January 2017 | anonymous | London | 4 |
<colgroup><col><col span="2"><col></colgroup><tbody>
</tbody>
How could I do this?
Thanks.