Pull and Match Random number

[MiGon]

Hi All,
I need a help with the attached data. Need to pull 12 random numbers for each ID.
I mean for each UNIQUE ID need to get number from colum B where ID matches

Thanks a mill
MiGon

 

[Fluff]

Hello @Fluff for me formula works perfect

Thanks for checking

I amended the formula to my scenario and works.

Glad we could help & thanks for the feedback.