Search : in
By :

Setting up Excel to pick numbers for my list

Last answer on Sep 4, 2008 10:30:18 pm BST jladika, on Aug 31, 2008 10:10:18 am BST 
 Report this message to moderators

Hello,
I would like to use Excel program to pick 6 numbers for a list i have.
can ths be done?

Configuration: Windows Vista
Internet Explorer 7.0

Best answers for « setting up Excel to pick numbers for my list » in :
Setting up a virtual private network (VPN) Show Setting up a virtual private network (VPN) Local area networks (LAN ) networks are internal to an organization, i.e. the connections between machines belong to the organization. These networks are increasingly connected to the Internet...
Excel: alphanumeric if then statements Show
Download Pop-up Excel Calendar Show Now, it is possible to avoid entering manually dates in Excel worksheets. With Pop-up Excel Calendar you can have access to date directly in your Excel worksheet. Pop-up Excel Calendar is an add-in for Microsoft Excel allowing to display a small...
MANDRIVA - Setting up SHOREWALL ShowMANDRIVA-Setting up Shorewall Getting started Checking if service is enabled at startup Enter your preferences Advanced Settings BitTorrent Multiple firewalls Linux like other OS doesn't escape the rule, it needs to be protected...
Setting up your own DNS Server ShowSetting up your own DNS Server Issue Solution Note Issue I have my own registered domain. I want to set up my own DNS server and host a website completely independent of any third party hosting service. I have Windows Server 2003 and...
Import contacts from Excel to Outlook ShowImport contacts from Excel to Outlook Issue Solution Issue How to import a contact list from Excel to Outlook and having them in a single list of contact , and not as splited items? Solution By using the software Excel 2000 and...
Download Pop-up Excel Calendar ShowDescription The application is designed by Office-Kit.com. Pop-up Excel Calendar is a tool that allows you to easily work with dates in Excel workbooks. Simple and easy to use, the application has been awarded from various places. It allows you to...
Download Random Number Generator Pro ShowRandom Number Generator Pro is a very simple tool to generate a random number list. There are several combinations and you can define the randomization criteria. You simply select the lower and upper limits as well as the number increments and the...
Download Query Manager for Excel Show
Introduction to setting up an intranet ShowStatus of this document This document explaining how to set up an intranet on a machine running Linux has been made possible through a partnership with www.tldp.org/, whose webmaster (Michel Maudet) is the author of the original document. What is...
Creating a local area network ShowWhy set up a local area network? When you have several computers, it can be convenient to connect them to each other to create a local area network (LAN). Setting up such a network costs very little, contrary to what people may think. Here are a...
Installing a VPN server on XP ShowInterest of a VPN Setting up a virtual private network allows you to connect remote computers in a secure fashion via an unreliable (Internet) connection, as if they were on the same LAN. This procedure is used by many companies in order to allow...
Ask your question Reply

1

adobepro, on Aug 31, 2008 3:37:27 pm BST
  • +1

Yes you can do that and if you dont know how to do it just see the help file you will find it there

   
Reply to adobepro

2

jladika, on Sep 2, 2008 2:42:49 am BST

I need someone to set this up for me please let me know if you can do this of if you know of anyone who can.

thanks I will send the numbers i will need .

thanks

Joe

   
Reply to jladika

3

Ivan-hoe, on Sep 2, 2008 2:12:43 pm BST

Hi Joe,
could you tell us more about what you want to do ?
what does your file look like ? where is the list of the numbers you want to pick out ?
Ivan

   
Reply to Ivan-hoe

4

jladika, on Sep 2, 2008 3:06:35 pm BST

Thanks for the reply
I have these numbers
3,5,6,13,16,17,18,20,23,25,26,27,28,32,34,35,36,40,42,44,46,­47,48,50,52 and 54

I would like to have the computer pick 6 of them.
i want to use the to play the lotto. So each week i will have the computer pick me a new slection.
thanks

   
Reply to jladika

5

Ivan-hoe, on Sep 3, 2008 9:35:17 am BST
  • +3

What you can do is use the function RAND, which generates random numbers between 0 and 1
You multiply it by 25 and then round it in order to get numbers between 0 and 25 (that is to say possibly 26 numbers corresponding to your list).
Then use the function OFFSET to choose a number in your list
Example :
your list is in A1:A26
B1 =ROUND(RAND()*25;0)
B2 =ROUND(RAND()*25;0)
...
C1 =OFFSET($A$1;B1;0)
C2 =OFFSET($A$1;B2;0)
...
Then press F9 for a new draw
Ivan

   
Reply to Ivan-hoe

6

 jladika, on Sep 4, 2008 10:30:18 pm BST
  • +1

I am sorry but i dont understand the formula.
please show me with real numbers in it.

   
Reply to jladika
Ask your question Reply
They need your help