Thread
:
How do I select a number from a specific group of numbers?
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
How do I select a number from a specific group of numbers?
try:
=--CHOOSE(INT(RAND()*4)+1,"1","5","7","8")
--
HTH
Sandy
In Perth, the ancient capital of Scotland
with @tiscali.co.uk
"motol" wrote in message
ups.com...
I need to randomly select one of the numbers out of the following
group: 1, 5, 7, 8.
Is there a formula I can use?
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann