Data ranges and dates

The UK's most regular instructor-led training courses.
Training information: excel+and+powerpoint+courses+uk · Excel advanced · VBA courses London

Resolved · Low Priority · Version Standard

Rachel has attended:
Excel VBA course

by - delegate Rachel [1 post] (2008 Mar 13 Thu, 16:33) Reply

I have a set of data. Each row of data has a date (or date range) assigned. How do I set something up so that I can choose an element of the data and then choose to look at a given monthly, quarterly or even yearly average?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Oct 15 Wed	Bloomsbury	0	FULL
2003	2008 Oct 15 Wed	Bloomsbury	0	FULL
2007	2008 Oct 15 Wed	Bloomsbury	0	FULL
2003	2008 Oct 17 Fri	Southwark	4	book now	£224	£235
2003	2008 Oct 22 Wed	Southwark	5	book now	£219	£235
2003	2008 Oct 22 Wed	Bayswater	5	book now	£195	£205
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Data ranges and dates

by - trainer Jacob silver contributer [92 posts] (2008 Apr 28 Mon, 17:35) Reply

Hi Rachel

Please pardon the "drop" in responding to this post.

It would help if you could provide some more information on your requirement, and if you can email us an example.

We can then gauge whether we can provide an answer quickly or if this looks to be more consultancy.

You can email info@microsofttraining.net subject "forum post question - Re Jacob"

Regards

Jacob