I have lists of names that need to be arranged in random order. Also the list
should only re-arange on <F9> and not on <enter>
I have lists of names that need to be arranged in random order. Also the list
should only re-arange on <F9> and not on <enter>
"John Murf" wrote
> I have lists of names that need to be arranged in random order.
> Also the list should only re-arange on <F9> and not on <enter>
One way ..
Assume names listed in A1:A10
Put in B1: =INDEX(A:A,RANK(C1,$C$1:$C$10))
Put in C1: =RAND()
Select B1:C1, fill down to C10
B1:B10 returns a random shuffle of the names in col A
Press F9 to re-generate
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Replied to OP:
-----------------------
Glad it helped, John !
--- john Murphy wrote:
> Hi Max,
> Thanks for the pointer to listing the names in
> random order, it works a
> treat.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Replied to OP:
-----------------------
Glad it helped, John !
--- john Murphy wrote:
> Hi Max,
> Thanks for the pointer to listing the names in
> random order, it works a
> treat.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks