Tag Archives: excel
Are you running a contest or sweepstakes an need a system to pick random winners out of a pool of names? You could take the old-school approach of writing names on business cards and pulling them out of a fishbowl, or you could use Microsoft Excel. Put the names in an excel sheet. add a column and put =RAND() in it. it will give a random number that is recalculated every time a change is made on the sheet. choose that column and click sort “a-z” (or z-a). it won’t matter because each time you do it will randomize the names. Just pick the top one (or top 10) after sorting it.
Excel Date Format Option 1 Use the WEEKDAY() Function to get the serial number of the day of the week. Excel Date Format Option 2 Format the existing cells as ddd dd/mm/yyyy hh:mm to show the day. Excel » format cells » custom format / custom date » format as above