Let me first day many thanks to anyone that can help with this.

I am currently using resampling with replacement on a sheet by defining a named range "sample" and using the following formula:

=INDEX(sample,ROWS(sample)*RAND()+1,COLUMNS(sample)*RAND()+1)

This works great when the sample data is only one column wide.

What I need to do is find a way to resample multiple cells in multiple rows but keep the rows intact. In the example below 1 is in column A, 2 is in Column B, 3 is in Column C, etc. 123,456,789 need to stay in that order no matter what row they are resampled to.

for example:
1 2 3
4 5 6
7 8 9

resampled w/ replacement:
4 5 6
7 8 9
4 5 6

Thanks a million for any help.