I came across an excelisfun video a while ago in which a lookup was used that showed all values in one cell. VERY similar to the textjoin(), but it worked in 2010.
....and of course, I can't find it, nor do I remember what I searched when I stumbled upon it....
I have a two column table, column A has names, column B has PO#s. I want to have a summary in which all the PO#s display in one cell.
Example:
Selection | PO Numbers |
Josh | 100, 150, 200 |
<tbody>
</tbody>
Name | PO Number |
Josh | 100 |
Jim | 99999 |
Josh | 150 |
Heather | 88888 |
Josh | 200 |
<tbody>
</tbody>
Does anyone know what I can search to find the video, or give me a starting point??
Thanks!