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