Concatenate in an array formula

[bucket42]

Hello,
Column A contains a list of my students.
Column B contains the subject name.
I would like a comma seperated list of student names for each subject.

If I do CONCATENATE(A1,A2,A3) then it works, if I do CONCATENATE(A1:A3)
it doesn't work. When I use an array formula to concatenate if the
subject name is correct then it doesn't work (because it returns a
single range of multiple cells rather than multiple ranges of single
cells).

Can anyone help me either with concatenate or with an alternative
solution?

Thanks.

 

[Peo Sjoblom]

You cannot do that, there are UDFs written for this, among many other
Laurent Longre's Morefunc has tons of useful functions and can be downloaded
from here

http://longre.free.fr/english/

installing instructions come with the download, function for your particular
subject is called

MCONCAT