Formula needed to generate report!
On Tue, 10 Feb 2009 22:01:01 -0800, Astro
wrote:
Dear all,
Help is needed!!! Currently I have a excel spreadsheet showing the following:
Part A 1 15-Jan-08
Part B 1 15-Jan-08
Part B 1 7-Jan-08
Part A 1 7-Jan-08
Part A 0 7-Jan-08
Part A 0 7-Jan-08
Part B 1 7-Jan-08
Part A 1 7-Feb-08
Part A 1 7-Feb-08
What formula can I use in order to generate a report to show that the count
for Part A is "2" under the month Jan 08 shown below:
Jan 08' Feb
Part A 2 2
Part B 3 0
Please help...... Thanks!!!
For generating a report, consider a pivot table
Label your columns.
Insert/Pivot Table or Data/Pivot Table
Drag dates to Rows area
Drag Part Names to Columns area
Drag the count to the data area.
Right-click on the Rows area in the pivot table and select Group. Then select
Months and Years.
Format to taste
--ron
|