-
Solved: All matched values in one Row
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules