You had trailing spaces in the Names A2:A11. Be ware of those. They can cause havoc for formulas. I cleaned them up in the attached.
In your profiled version of Excel you will need VBA to concatenate the desired results in a single cell. The user defined function Concatall by tigeravatar will do this. Here is the code.
While the above code is already installed in the attached here is how it is done.
How to install your new code
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the code into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
Then array enter this formula in G30 and fill down. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
Bookmarks