Hmmm... 5 groups of 4 numbers out of 16 without duplication isn't
possible (you'd need at least 20).

You might find one of the techniques here helpful:

http://mcgimpsey.com/excel/udfs/randint.html



In article ,
xpert 1 <xpert wrote:

Can anyone help with this?

I wish to use say 16 numbers in groups of 4 on 5 seperate occasions and not
have the same number apear twice with any other numer used previously?

Is this able to be done or am I expecting too much!