Matt wrote:
Hi John,

It all sounds very promising, but I do have a stumbling block (I'm sure it's
just me being daft). When you say cell A1 should be equal to my Fiscal Year,
how should I input that? should it be "01/04/08 - 31/03/09" or just "Apr 08
- Mar 09"?

It just seems everything I try returns an error from the formula you gave me.

Thanks again
Matt



If you haven't already, please consider a PivotTable for your report. It will
do exactly what you need.

Select your data range. Select Data / PivotTable and PivotChart Report. In the
wizard, select "Microsoft Office Excel list or database" and "PivotTable" and
then Next. Confirm the range and click Next. Select "New worksheet" and Finish.

Drag "Source of Booking" to Row Fields area. Drag "Arrival Date" to Column
Fields area. Drag "Commission Paid" to Data Items area.

Right-click on "Arrival Date" on the PivotTable and select Group and Show Detail
/ Group. Click "Months" and "Years" in the "By" list (both should be
highlighted). Un-check the "Auto" boxes for "Starting at:" and "Ending at:" and
fill in the appropriate dates (4/1/2008 and 3/31/2008 for your current fiscal
year). Click the pop-up for "Years" and un-check "<4/1/2008" and "3/31/2009".

Right-click on "Commission Paid" on the PivotTable and select Field Settings.
Click "Number" and format data, if necessary.