LinkBack URL
About LinkBacks
Hi, I need to shuffle a spreadsheet for a blind review. Spreadsheet A-H and with about 1000 rows. Anybody knows a function for this?
Cheers, Seneca
Hi, I need to shuffle a spreadsheet for a blind review. Spreadsheet A-H and with about 1000 rows. Anybody knows a function for this?
Cheers, Seneca
Welcome to the forum.
In an unused column, enter and copy down =RAND(), then sort the whole ensemble by that column.
Entia non sunt multiplicanda sine necessitate
Please redefine your question.
Range A1:H1000 is full of data. What kind of data? What should be the end result? What is meant with shuffle?
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
Hi, It is clinical data. Each row has patient details / trial results spread in columns A to H. I've got about 1000 entries and I need to shuffle them for a blind randomized review
Originally Posted by rwgrietveld
The copy down =RAND() in I1:I1000 and sort by that column like shg suggested.
Thanks, I think it works!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks