Excel Array Guide

[Russinating]

I'm looking for a decent guide on using arrays in excel - and advice on whether that's actually what I need!

Say I've got a list of students in column A and then a selection of 5 course choices in column B, I want to create a new column with the heading "Course 1" that then lists all the students who've chosen that course.

Cheers for your help

 

[Russinating]

Based on a few things I've just read wont that try to add up the names as a calculation, rather than storing all the names seperately and then entering them each into a different cell?

 

[Russinating]

Column A............Column B........Maths..............Science.........English
Bobby Blue............Maths.............Bobby Blue........ Roger Red.......Penny Pink
Roger Red.............Science...........Gary Green
Gary Green............Maths
Penny Pink............English