Fantasy Football program (kinda)

Is there some way to use EXCEL or another program to generate randomizing list?

I'm the league commissioner for our league. We have 10 people divided into two divisions.

Is there a way to list all 10 people then have them randomized ordered 1-10 (for draft selection) then assigned a random division? Either division 1 or division 2?

Yahoo and most other FF leagues do this already...

A quick dirty way is just to make lots of columns.

Column A has the names of each person
Column B has =RAND() drag this down for all 10 people
Column C has =RANK(B1,B$1:B$10) drag this down for all 10 people
Column D has =RAND() drag down...
Column E has =RANK(D1,D$1$10) drag down...
Column F has =IF(E1<=5,"div 1","div 2") drag down...

now hide columns B, D, and E

Note that every time you calc the rand values change and the ranks and divisions will change, you can do this by pressing F9 or entering something new in any cell. If you don't want this to happen turn off Auto-calc in the options.

If you have an iPhone or iTouch there has got to be an app for that with all those fantasy football apps out there.