Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel
Is there a function in Excel for text, similar to the RANDBETWEEN function for numbers? <br><br>I have a list of names, and I want to make 40 new lists of the same names, with each list in a randomly assorted order. <br><br>Short of assigning each name a number, then randomizing the numbers, and then translating it back to the names, can this be done in a single step? <br><br>Thanks.
|
|
0
|
|
|
|
Reply
|
 creevs
|
12/3/2009 8:44:48 PM |
|
creevs@officeformac.com wrote:
> Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel
> Is there a function in Excel for text, similar to the RANDBETWEEN
> function for numbers?
>
> I have a list of names, and I want to make 40 new lists of the same
> names, with each list in a randomly assorted order.
>
> Short of assigning each name a number, then randomizing the numbers, and
> then translating it back to the names, can this be done in a single step?
>
> Thanks.
Hi,
Well, instead of using something similar, why not use RANDBETWEEN?
In order to use RANDBETWEEN you have to turn on the Analysis Toolpak. To
do this:
1. Open a blank workbook
2. On the Tools menu choose Add-ins
3. Click the checkboxes next to Analysis Toolpak
4. Click OK to close the dialog box
-Jim
--
Jim Gordon
Mac MVP
Co-author of Office 2008 for Mac All-in-One For Dummies
http://tinyurl.com/Office-2008-for-Dummies
|
|
|
0
|
|
|
|
Reply
|
Jim
|
12/3/2009 11:54:14 PM
|
|
In article <59bae151.-1@webcrossing.JaKIaxP2ac0>,
creevs@officeformac.com wrote:
> Version: 2004
> Operating System: Mac OS X 10.4 (Tiger)
> Processor: Intel
>
> Is there a function in Excel for text, similar to the RANDBETWEEN function
> for numbers? <br><br>I have a list of names, and I want to make 40 new
> lists of the same names, with each list in a randomly assorted order.
> <br><br>Short of assigning each name a number, then randomizing the numbers,
> and then translating it back to the names, can this be done in a single step?
> <br><br>Thanks.
Take a look here (replacing integers in the second method with your list
of names:
http://www.mcgimpsey.com/excel/udfs/randint.html
|
|
|
0
|
|
|
|
Reply
|
JE
|
12/12/2009 6:31:09 PM
|
|
|
2 Replies
145 Views
(page loaded in 0.073 seconds)
Similiar Articles: Random numbers, letters, pictures? - microsoft.public.powerpoint ...I know how to generate numbers randomly, but how do I ... one, or are they in a file, and you need to insert them? ... returns the character that is represented by the given ... Random Population from list - microsoft.public.mac.office.excel ...Have you looked at the RAND function ... 67356835 Content-type: text/html ... excel ... random select a ... randomly select a given percentage of values from your custom list ... Generating random numbers - microsoft.public.excel.worksheet ...... Excel, you really have not given enough ... I need to put these numbers randomly in ... golf draws I wish to create a vba function that will generate all the numbers in a given ... text as value in pivot table - microsoft.public.excel.worksheet ...... A11_1a in a table, and with the order given by ... can use Pivot Table or any other similar function so that I can get text ... For example, if you add the Region field to ... VBA to merge worksheets (only populated rows) - microsoft.public ...(I started tying to add comments to help explain the function but not finished ... however we noticed it seems to randomly add some ... If I record "Home" the macro given refers ... Pivot table for worksheet text fields? - microsoft.public.excel ...... cell) all the text answers given in response to Question 4? If not, is there some other Excel function ... pivot table ... text field to count the tasks, you can add a ... Using the Insert key to switch between insert & overwrite mode ...I > was simply given a syllabus that specified ... Re: How to enable INSERT Key function for Word 2007 Re: Using the ... There are three primary ways to insert text into ... Search will not find text in picture - microsoft.public.onenote ...Besides this issue, I seem to not be able to “insert ... as valid even thou it is the number that is given to ... Find Text in List Box - microsoft.public.access.forms I've ... Counting the number of unique different values in a set ...... so I would like the function to return 2, even if I select 100 rows all with data. <br><br>Another example: <br> Given the following list ... the second column and add ... How do you randomly assign numbers without getting duplicates ...I'm trying to randomly assign a number between 1 and 9004 for a mailing list ... something agains add-ons - you may try installing "MOREFUNC" One of its built-in functions ... Function (mathematics) - Wikipedia, the free encyclopediaFor instance, one can interpret Add(3,5) to mean "first produce a function that adds 3 to its ... for such functions, more specifically by saying that a (given) function ... Excel Random Formula/Functions: Pick a number, name or item at random*A Volatile function is a function that recalculates when you enter any data ... It will also be dynamic in that when/if you add/remove names from the list they will ... EXCEL VALUE Function - Excel Text FunctionsThe VALUE function, one of Excel's text functions, is used to convert text to numbers. Doing so allows them to be used in calculations. This article includes an ... Excel Functions ListExcel Functions List with Full Description of Each of Excel's ... Returns a text string depicting the roman numeral for a given number Custom Excel Formulas. Custom Excel Functions/UDF. Excel User ...How about A Free Handy Excel Functions Add-in? ... the numeric portion from a Text String. TOP^ List/Return ... Return Date of Last Chosen Day of Given Month: Custom function ... 7/31/2012 5:51:30 AM
|
Search |
Post Question |
Groups |
Stream |
About |
Register
14 followers. 