Here's a way to do this with formulas - you need one helper column

To get your numbers 0-99 with no repeats in A1:J10

use this formula in L1 and copy down to L100
=RAND()

Put this formula in A1 and copy across to J1 and down all 10 columns to
row 10
=RANK(INDEX($L$1:$L$100,ROW()+10*(COLUMN()-1)),$L$1:$L$100)-1

hide column L if you wish

random numbers are regenerated every time sheet is recalculated (hit
F9)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=508266