Random number generator

[bdd]

Our organization sold raffle tickets for a fundraiser. The tickets were numbered 1 - 2500, but we only sold 1100 tickets (the range of tickets sold are 1 - 2500). I have the ticket numbers entered into an excel spreadsheet in a column. I would like to have excel generate a random number from this list of sold tickets (not all tickets were sold). I currently have excel generating a random number from 1 - 2500, but I don't want to generate a random number, look to see if that ticket was sold and if it wasn't generate another random number. Is there a way to reference the list of sold ticket numbers within the random number generator function?
Thanks in advance for your help.

 

[pgc01]

Hi bdd

Instead of generating a random number 1-2500, generate a random number 1-1100 and take the corresponding ticket from the list of the sold tickets.

 

[Michaels]

Our organization sold raffle tickets for a fundraiser. The tickets were numbered 1 - 2500, but we only sold 1100 tickets (the range of tickets sold are 1 - 2500). I have the ticket numbers entered into an excel spreadsheet in a column. I would like to have excel generate a random number from this list of sold tickets (not all tickets were sold). I currently have excel generating a random number from 1 - 2500, but I don't want to generate a random number, look to see if that ticket was sold and if it wasn't generate another random number. Is there a way to reference the list of sold ticket numbers within the random number generator function?
Thanks in advance for your help.

Hello BDD and Welcome to the Forum !

You have tickets, which are serially-numbered from 1 to 2500. You have sold 1100 tickets (now left with 1400 tickets).

Are you looking for this:

Excel Workbook
	A	B	C
1	Ticket No.	Status	Randomly-generated sold ticket no.
2	1	Sold	Sold
3	2	Available	1037
4	3	Sold	Sold
5	4	Sold	Sold
6	5	Sold	Sold
7	6	Available	1038
8	7	Available	1004
9	8	Available	290
10	9	Available	1085
11	10	Available	176
Sheet1

Excel 2007

Cell Formulas
Range	Formula
B2	=CHOOSE(RANDBETWEEN(1,2),"Sold","Available")
B3	=CHOOSE(RANDBETWEEN(1,2),"Sold","Available")
B4	=CHOOSE(RANDBETWEEN(1,2),"Sold","Available")
B5	=CHOOSE(RANDBETWEEN(1,2),"Sold","Available")
B6	=CHOOSE(RANDBETWEEN(1,2),"Sold","Available")
B7	=CHOOSE(RANDBETWEEN(1,2),"Sold","Available")
B8	=CHOOSE(RANDBETWEEN(1,2),"Sold","Available")
B9	=CHOOSE(RANDBETWEEN(1,2),"Sold","Available")
B10	=CHOOSE(RANDBETWEEN(1,2),"Sold","Available")
B11	=CHOOSE(RANDBETWEEN(1,2),"Sold","Available")
C2	=IF(B2="Available",RANDBETWEEN(1,1100),"Sold")
C3	=IF(B3="Available",RANDBETWEEN(1,1100),"Sold")
C4	=IF(B4="Available",RANDBETWEEN(1,1100),"Sold")
C5	=IF(B5="Available",RANDBETWEEN(1,1100),"Sold")
C6	=IF(B6="Available",RANDBETWEEN(1,1100),"Sold")
C7	=IF(B7="Available",RANDBETWEEN(1,1100),"Sold")
C8	=IF(B8="Available",RANDBETWEEN(1,1100),"Sold")
C9	=IF(B9="Available",RANDBETWEEN(1,1100),"Sold")
C10	=IF(B10="Available",RANDBETWEEN(1,1100),"Sold")
C11	=IF(B11="Available",RANDBETWEEN(1,1100),"Sold")

Thanks

 

[Michaels]

Hi!

Sorry my mistake, use =RANDBETWEEB(1,400) if you want to generate random serial numbers of unsold tickets. Or use =RANDBETWEEN(1,1100) if you want to generate the numbers of sold, as the case may be.

 

[bdd]

Hi bdd

Instead of generating a random number 1-2500, generate a random number 1-1100 and take the corresponding ticket from the list of the sold tickets.

Good idea......thanks!