Concatenate in an array formula

  • Thread starter Thread starter bucket42
  • Start date Start date
B

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.
 
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
 
Back
Top