Hi,

Need help..!

Based on a certain criteria, I want all the corresponding cell values to appear in the same cell.

Am attaching an example:
Where ever the metric = 2, I want the value(from column A) returned in the same cell. Basically the correponding values should be concatendated and displayed in a single cell.

So the output in the cell would be: a;d;e;f.

Also, I have to do this without VBA.

thanks a lot for the help,

asingh