Latest Lists

how do you make a list that will select objects within i at random?

I'm making a list on Microsoft Excel and i want it to select the objects in the list on a daily basis at random. Suggestions will help lots. Thanks.

Public Comments

1. Add in column B next to data =RAND() and copy to match data In another column enter =INDEX(A:A, MATCH(SMALL(B:B,ROWS($1:1),B:B,0)) Copy down as many times as items you want to select ie 5 if selecting 5 objects. Turn off Autocalculate, repick items by pressing F9.