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

 

[MiGon]

With the sample you gave not all of the values occur 12 times.

sorry, my fault. There is more, hundrets for each ID. Would you need bigger sample?

 

[Fluff]

As long as you change the ranges in formula to look at your entire data, it should return 12 values.

 

[MiGon]

Thanks, will change the ranges hopfully gonna get this working

 

[Fluff]

Let us know if you have any problems.

 

[MiGon]

Hi Fluff, looks cannot get that right even when change ranges cannot get that working, I have 16636 numbers this month and that is changing each month.

 

[Fluff]

In what way isn't it working? also what is your amended formula?

 

[MiGon]

Sorry for bothering you again, this is the formula

=IFERROR(INDEX($B$2:$B$16636,AGGREGATE(15,6,(ROW($B$2:$B$16636)-ROW($B$2)+1)/($A$2:$A$16636=$D2)/($C$2:$C$16636=SMALL(IF($A$2:$A$16636=$D2,$C$2:$C$16636),E$1)),1)),"")

and getting blanks

 

[Fluff]

Thanks for that & it looks fine, in what way isn't it working?

 

[MiGon]

nope

 

[Fluff]

That doesn't answer my question.