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.
[TABLE="width: 578"]
<colgroup><col><col span="2"><col></colgroup><tbody>[TR]
[TD]Week Commencing[/TD]
[TD]Name [/TD]
[TD]Location[/TD]
[TD="align: right"]Days[/TD]
[/TR]
[TR]
[TD]02 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]02 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]02 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]02 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]09 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]09 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]09 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]09 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]16 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]16 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]16 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]16 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]4[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 578"]
<colgroup><col><col span="2"><col></colgroup><tbody>[TR]
[TD]Week Commencing[/TD]
[TD]Name [/TD]
[TD]Location[/TD]
[TD="align: right"]Days[/TD]
[/TR]
[TR]
[TD]02 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]02 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]02 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]02 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]09 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]09 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]09 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]09 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]16 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]16 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]16 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]16 January 2017[/TD]
[TD]anonymous[/TD]
[TD]London[/TD]
[TD="align: right"]4[/TD]
[/TR]
</tbody>[/TABLE]
How could I do this?
Thanks.