Hello,

I receive the pivot table from other department regarding student's activities
performance. Some of students joint same activities , some of them only join
one
activity. There are 1000 students in file. I only require 200 students. I
don't
have the source files. There are no grouping/ similar characteristics, so I
can't use grouping of pivot table to select those 200 students.

The format as following

RM Name Campaign Name % of unattend % of bad performance % of positive
comment
Dick Lau 99999* Anti-Smoke 0 50 90
Dick Lau 99999* Communication Skill 10 60 80
Dick Lau 99999* interpersonal skill 11 55 70
Dick Lau 99999* Play group 20 60 60
Gordon Lau 99999* Anti-Smoke 0 23 100
Gordon Lau 99999* Communication Skill 11 32 90
Gordon Lau 99999* interpersonal skill 4 32 60
Gordon Lau 99999* Play group 5 55 40
Gordon Lau 99999* leadership 10 55 22

I just need students following 5 data:
"Sum of % of unattend
(all activities)"

"Sum of % of bad performance
(all activities)"

"Sum of % of
positive comment (anti smoke)"

"Sum of % of positive comment
(play group)"

"Sum of % of positive comment
(interpersonal skills)"

I wouuld like to use index and match function/ VBA. It seems that formula
function is possible. I receive this file every week, there may be new
activities in the later week. Therefore, it is much better to use formula
function. If using VBA, after they add new activities, the macro may be
require
to modified.

I have the excel file for reference. However, I tried several times, I still
can't upload the file in the forum. I use firefox browser.