Return string of matched occurrences
I have a workbook with two worksheets. One contains a list of classes (a number value, which may be a decimal like 34.5) and the names of the students. The other has notes on the students.
In the second worksheet I would like to have a column that shows the classes in which the student has participated (see Column-E in the example image).
The class number and names are usually sorted in ascending order. It would be good, but not required, if this were not a dependency on any formula working. I'd prefer not to use VBA, if at all possible.
Is this possible, and if so then how?
Thanks in advance,
Andrew
|