Re: Random Function in Excel
Nicole Massey <nyyki@...>
I'd use randbetween instead of rand in this instance, and here's what I'dtoggle quoted messageShow quoted text
do. Others may have different suggestions.
Put your names in column b, then do a randbetween formula in column a with a
huge number to minimize repetition, say a hundred million. The command is
=randbetween(0,100000000) and put it next to every name in the list. Then
sort the names smallest to largest, using the context sensitive menu or
whatever other sorting path you want to take.
From: email@example.com [mailto:firstname.lastname@example.org] On Behalf Of Steve &
Sent: Friday, July 15, 2016 9:59 AM
Subject: Random Function in Excel
Using JAWS 17, Excel 2010 and Windows 10. I have an Excel spread sheet with
names in column A on rows 2 through 200. I want to use the random function
to create a formula to use in order to select a person's name to use for
door prizes. I can't figure out how to write the formula. Thanks in
advance for any assistance!