bananatang
01-13-2009, 10:11 AM
Hi,
I would like to create a macro that will apply a countif formula to specific column to a excel spreadsheet (pivot table) which contains batches of data.
I am attempting to calculate the unique no. individual pupils who have been given an exclusion. i.e. The data in a section may show a pupils may have more than one exclusion in a term.
What i need the macro to do is within that each batch of data to apply the countif formula to count the number of unique individual pupils. The countif formula i use does this. I just need to apply this formula to each section of the spreasheet and for the formula to change according to the start and end of that particular section.
The data is separated in order to indentify what type of school it is i.e Primary, Secondary as well as by type of exclusion i.e. fixed permanent etc.
i have attached a copy of a document which shows the data and in the last column i have applied the countif formula as i have done in the past manually for each section. I would like to have a macro that would do this instead of me manually going to each section of the report and adjusting the formula for the given section of the report.
If anyone knows of a better way to do this, i would appeciate your help too.
Any help would be appreciated.
BT
I would like to create a macro that will apply a countif formula to specific column to a excel spreadsheet (pivot table) which contains batches of data.
I am attempting to calculate the unique no. individual pupils who have been given an exclusion. i.e. The data in a section may show a pupils may have more than one exclusion in a term.
What i need the macro to do is within that each batch of data to apply the countif formula to count the number of unique individual pupils. The countif formula i use does this. I just need to apply this formula to each section of the spreasheet and for the formula to change according to the start and end of that particular section.
The data is separated in order to indentify what type of school it is i.e Primary, Secondary as well as by type of exclusion i.e. fixed permanent etc.
i have attached a copy of a document which shows the data and in the last column i have applied the countif formula as i have done in the past manually for each section. I would like to have a macro that would do this instead of me manually going to each section of the report and adjusting the formula for the given section of the report.
If anyone knows of a better way to do this, i would appeciate your help too.
Any help would be appreciated.
BT