| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help me to generate a report | New Users to Excel | |||
| Can I generate a report for my classroom? (I APPRECIATE YOUR HELP | Excel Worksheet Functions | |||
| Problem trying to generate a report with a formula | Excel Discussion (Misc queries) | |||
| Issue with a formula to help generate a report. | Excel Worksheet Functions | |||
| Generate Report | Excel Worksheet Functions | |||
Threaded Mode
