Thread
:
Can I randomise the order of a number of rows?
View Single Post
#
5
Max
Posts: n/a
Can I randomise the order of a number of rows?
Oops, pasted the formula from the wrong cell ..
Line:
Put in C1: =INDEX(A:A,RANK(B73,$B$1:$B$100))
should be:
Put in C1:=INDEX(A:A,RANK(B1,$B$1:$B$100))
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
Reply With Quote