Lookup a list of values and return values in singe cell concatenated format

[rstuart76]

Hi - looking for a formula/code to lookup a range of values from a matched value and present them in a single cell concatenated format including range and comma separator:

There will sometimes be sequential values that can be ranged i.e. 100-106 but then there may be single values so needs to display i.e. 100-106, 110

DATA

R/C	A	B
2	Name	Code
3	Robby	2234
4	Robby	2235
5	Robby	2236
6	Robby	3455
7	Dave	9867
8	Dave	9868
9	Dave	3232
10	Dave	1112

<tbody>
</tbody><colgroup><col span="2"><col></colgroup>

OUTPUT TO:

Name	Code Range
Robby	2234-2236,3455
Dave	9867-9868,3232,1112

<tbody>
</tbody><colgroup><col span="2"></colgroup>