i have a worksheet that contains lists of proposed attendees for various
courses with an identifier if they actually attended. the names in the list
can be repeated if they proposed to attend more than one course. i would like
to create another worksheet that will return the name of each person proposed
to attend with the number of courses actually attended. the main problems i
am having is how to return the name once even if it is repeated throughout
the list and how to count the number of courses each person has attended. i
am not sure if it is possible in Excel or if i should be using Access instead.