Re: randomizing

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Dawn Crosier, Word MVP" <dlc110161@xxxxxxxxxxx>
Date: Mon, 19 Feb 2007 17:37:52 -0600

Copy and paste them into Excel and then in the next column over use the Rand
Function to generate a number. Then sort on that column. This will not be
100% random, however it should be 99.9% random. The true Excel guru's know
that the Random function is flawed, but for what you want to do, it should
be sufficient.

--
Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"

This message was posted to a newsgroup, Please post replies and questions
to the group so that others can learn as well.
"DC3DKB" <DC3DKB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EB5973A0-1F9F-4155-A265-758D366377A2@xxxxxxxxxxxxxxxx
Is there a way to randomize a list of 100 text (alpha) items?

.

Prev by Date: Re: Repairing Office 2003 after Office 2007 uninstall
Next by Date: Re: Outlook 2003 "Operation Failed"
Previous by thread: Re: Repairing Office 2003 after Office 2007 uninstall
Next by thread: Re: Can I convert a color jpg to grayscale in Picture Manager?
Index(es):
- Date
- Thread

Relevant Pages

Re: SORTING question
... I'm just going to pass along some general (Excel) sorting advice. ... When you tell Excel to sort, you can do so in several ways. ... > about having the original order disrupted because occasionally I will have ...
(microsoft.public.excel.newusers)
Re: Sorting
... Wouldn't it be easier to use a software package like Family Tree Maker ... Why do you think you can make Excel sort in a different manner ... you certainly cannot use Excel alone to sort your data. ... need a macro to sort each column twice by creating a text string ...
(microsoft.public.excel.programming)
RE: Sorting Alphanumeric data in Excel 2003
... Do you mean that you can sort the data as you expected in Excel 2000/2002? ... Microsoft Online Partner Support ... | cell format is also copied when you copy/paste in Excel. ...
(microsoft.public.excel.setup)
Re: Update Query to Overwrite Old Data Automatically
... Rather than trying to update the Excel ... Spreadsheet, why don't you just provide them a new spreadsheet each month? ... Is this some sort of web based database application? ... The database does already have a last updated field. ...
(microsoft.public.access.queries)
Re: Automatic Sorting?
... LOOKUP functions but finds the value based upon a row and column index ... >>> Is there a way that Excel can automatically sort a> column? ... >>> Scott B. Hogle ...
(microsoft.public.excel.programming)