Apr 03 2019 04:00 PM
Apr 03 2019 04:24 PM
Apr 03 2019 04:49 PM - edited Apr 03 2019 04:51 PM
@Sam-L Consider the following screenshot:
Create a list of unique numbers. This can be done in various ways, for example with a pivot table. If you want an approach for that aspect, please pipe up.
Then you can use a TextJoin function, which is a new function in Excel 2019 and Excel 365. It is not available in earlier versions.
=TEXTJOIN(" ",TRUE,IF($A$1:$A$5=D1,$B$1:$B$5,""))
This is an array formula and must be confirmed with Ctrl + Shift + Enter (unless your Excel version already has the new dynamic array functions enabled).