Quote:
Originally Posted by gebobs
Pivot tables are as intuitive and easy as they are powerful. The best way to learn is to play around with them. I'll get you started though...
In a new sheet...Insert Pivot Table
Enter the data range from Sheet 1
Press OK.
In the Pivot Table Field list, check Training Type and Training Start Date. They will appear as Row Labels.
Click and drag Name Surname to the Values Box. It will appear as Count of Name Surname.
Right click on any of the dates that now appear in the pivot table. Select Group. Highlight months and years. Click OK.
|
Thnks for your help but, in sheet 2 we should show the numbers of people in monthly breakdown. In pivot table only show us the case in table. Maybe ı may not do what you say.
Could you do a formulation for sheet 2 and then we can use a pivot table? Is it possible?