Text Function
 

Is there a text function counterpart to the SUMIF. A concatenate if? I have
a table of data and based upon a numeric value in the data I would like to
concatenate all of the text strings that might be assocaited with all of the
instances of a given numeric value...