Thread
:
Random pick of a cell
View Single Post
#
4
Posted to microsoft.public.excel.misc
Max
external usenet poster
Posts: 9,221
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
---
Reply With Quote
Max
View Public Profile
Find all posts by Max