View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Random pick of a cell

Then just place in say, B2:
=INDEX(D$2:D$4,RANK(E2,E$2:E$4))


well, if you want a full random shuffle of the source in D2:D4, just copy B2
down to B4.

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---