I have a list of names in cells A1:A100, and I'm looking for a formula to enter into a cell that will select a random name from that range. I have spent much time searching to no avail, all solutions seem to be derived from the RANDBETWEEN function which is not part of Excel 2003, but only newer versions. This seems like a very common thing to want to do so I'm really surprised there is no easy-to-find solution. Help is much appreciated =)
Generate random item from list Excel 2003
300 Views Asked by Allen Jones At
1
There are 1 best solutions below
Related Questions in LIST
- How to give the player the ability to choose a grid in Battleship?
- Sorting a List by its property renames all the objects in the List
- Replace NA in list of dfs in certain columns and under certain conditions
- Why does print(list.sort()) result in None?
- How to distribute the sum of several numbers similarly?
- Random getting value from a range or a specific value
- drop down list to decide which range my graph will plot
- List > numpy.ndarray using np.array(list) not working in class __init__ . Problem with numpy?
- Creating an efficent and time-saving algorithm to find difference between greater than and lesser than combination
- Flutter: How to add items and save it in local storage?
- Why my code is working on everything except one instance?
- Why does the following code detect this matrix as a non-singular matrix?
- How do I convert a list of chars into a list of strings in F#?
- Going back to an earlier index in list iteration
- If the element(s) in the first list equal element(s) of the second list, replace with element(s) of the third list
Related Questions in RANDOM
- Producing filtered random samples which can be replicated using the same seed
- Random getting value from a range or a specific value
- Unique and random selection of 10 rows per user in a table
- How to calculate the accuracy in number guessing game?
- Using attributes from instances of array of objects in other classes
- How do I write such a random source code generator?
- How to randomly load html file inside a html page on page load using javascript?
- New error on random number assigned to local variable , Rails
- Why does the code return the same 5 random numbers every time
- How can I efficiently find two numbers in an array that sum up to a given target without using the same element twice?
- How can I use a variable that is defined in one script in a different script in Unity
- Why is C# BigInteger not always the same bit length?
- Choosing a sequence of bitwise operations
- java: method nextLong in class java.util.Random cannot be applied to given types;
- How to add the outout the random element from array and keep adding 1 by 1 in empty array?
Related Questions in EXCEL-2003
- Find cells in excel which have a format other than General like Custom
- Get column index matching the date value in excel
- Setting Range Using xlToLeft Fails After 256'th Column
- Passing double array to Variant failing
- Excel 2002 XML Spreadsheet - validation trouble
- Filling data via series AutoFill without dragging
- excel 2003 database fields - is it possible to change the name
- Xl.Read.File function doesn't read all the rows
- Is it possible to append multiple .xls files into a single Excel 2003 worksheet without Office Interop?
- "Runtime Error 1004: Copy method of worksheet class failed " in VBA on first copy attempt
- How to calculate time difference in seconds between two cells, where cells are formatted as text in format "yyyy-mm-dd hh:mm:ss"?
- VBA RunTime Error 445 - Application.FileSearch
- How to Transfer a Web Page (Code) to a String Variable in VBA
- Macro doesn't protect back my ws properly
- Check if Autoshape exists
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
If you can't use RandBetween(), you can still use Rand(), which delivers a decimal number. Round the decimal number to 2 places, then multiply by 100 to get a number between 0 and 99. Add 1 to get a number between 1 and 100
Feed that into an Index function like this
Done.