One possible way ...

Assuming your data range is in Sheet1, A1:H8 (as before)

1) Do this set-up in a new sheet, say in Sheet2:

--------------------------------------------------------

Number 1 to 64 down C1:C64

Put in D1: =Sheet1!A1

copy down to D8 (down 8 rows)

Put in D9: =Sheet1!B1

copy down to D16 (down 8 rows)

Put in D17: =Sheet1!C1

copy down to D24 (down 8 rows)

And so on. Repeat in a similar way until D1

64 are filled

(this provides the links to your data range in Sheet1, A1:H8)

Name the range C1

64 as : DataTBL

Put in B1: =RAND(), copy down to B64

Name the range B1:B64 as : RandTBL

Select A1:A64

Put in the formula bar: =RANK(RandTBL,RandTBL)

Array-enter the formula, viz.:

Hold down CTRL + SHIFT, press ENTER

(instead of just pressing ENTER)

Done correctly Excel will wrap curly braces around the formula:

{=RANK(RandTBL,RandTBL)}

(don't type-in the curly braces!)

Name the range A1:A64 as : RankTBL

-----------------------------------------------

2) With the set-up above done,

In any new sheet, say in Sheet3:

-------------------------------------

A. Generating Row-wise

------------------------------

Put in A1: =VLOOKUP(INDIRECT("Sheet2!A" & ROW()+COLUMN()-1),DataTBL,2,FALSE)

Copy A1 across as desired, say:

to E1, for 5 unique random selections from your data-table.

to J1, for 10 unique random selections from your data-table

and so on

You can generate up to a max 64 "row-wise" unique random

selections from your datatable (in A1:BL1)

Pressing F9 gives another random selection

B. Generating Column-wise

---------------------------------

Put in any cell, let's take A1: =VLOOKUP(Sheet2!A1,DataTBL,2,FALSE)

Copy A1 down as desired, say:

to A5, for 5 unique random selections from your data-table.

to A10, for 10 unique random selections from your data-table

and so on

Again, as before, you can generate up to a max 64 "column-wise"

unique random selections from your datatable (in A1:A64)

Pressing F9 gives another random selection

--

hth

Max

-----------------------------------------

Please reply in newsgroup

Use xdemechanik

<at>yahoo<dot>com

for email

-------------------------------------------