alternator 12:37 21 Jan 2012
Locked

Firstly I am fairly green on full development of spreadsheets, I can build them using the available functions, such as VLOOKUP, IF, RAND, SUM, AVG etc but writing macros is beyond my capabilities What I would like to do is to generate a spreadsheet on an old Dell Axim (palmtop) that runs pocket Excel which seems to have most of the functions available that a full version of Excel has. My plan was to make a spreadsheet which I could use to generate a random digit which corresponds to cloak room tickets sold, to save having to rip off the corresponding numbers and go through the nausea of ripping and folding the corresponding tickets to those sold. So I need to enter the two numbers between which the sold ticket numbers exist say 36-115, then generate a random number between these (note there is no RAND BETWEEN function on pocket EXCEL or at least not this version. I can do that no problem using the RAND function. But where I come unstuck, is when I want to keep pulling out more random numbers, because ideally I don't want to repeat the numbers that have already been pulled. I can obviously enter the numbers of the tickets that have been pulled in one column and use a VLOOKUP and a whole lot of IF arguments, but this becomes totally unwieldy, I feel sure there must be a neater solution to this without resorting to writing macros, which are beyond my capabbilities

Terry Brown 13:14 21 Jan 2012

The problem is simply solved by when a number has been used that number is changed to 0 (zero)so it can not be used again.

Terry

alternator 17:23 21 Jan 2012

Thanks Terry, I am probably being a bit thick. But what I had envisaged was a cell with the starting number of the cloakroom tickets and one with the end number of the cloakroom tickets. Then to have a cell which calculated last number less the first ticket number. Then to multiply this cell by the RAND cell to generate the random number, then add the starting ticket number so the random number then is a number corresponding with one of the tickets bought. When I enter the generated ticket number in the column of winning tickets it will generate another number, but my problem, is using this system it is quite possible it will generate number that has already been selected. This is what I am attempting to avoid. So I am saying the actual numbers of the tickets is not physically entered.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iPhone X review

Political cartoons in 2017: Chris Riddell, Rebecca Hendin and Dave Brown on what it’s like to…

The best iPhone for 2017

Tennis : comment regarder la finale de la Coupe Davis 2017 ?