Then they won't be really random if they can't be repeated.you can do this
though
Put all the integers you want to include in your rand in column A like
A1:A100

1
2
3
and so on


then in B1 put

=RAND()


copy down as long as needed for example to B100,
select both columns and sort by B ascending.
select how many you need in column A from A1 on and copy them somewhere else
and that would be your "random" integers without repetition


--


Regards,


Peo Sjoblom




"Terry" wrote in message
...
Yes I am able to use Rand with INT functions, but resulting numbers
duplicate randomly which I wish to avoid. Also is it possible to "retain"
these random numbers as I am using for a bingo game on a coach trip, so
need to cross check numbers gone.(1-90)

Appreciated

Terry
"daddylonglegs" wrote in message
...
Can you use RAND() function in conjunction with INT?

e.g. these are eqivalent

=RANDBETWEEN(1,10)

=INT(RAND()*10+1)

"Terry" wrote:

Thank you Peo
Terry
"Peo Sjoblom" wrote in message
...
There are no ATP functions in mobile Excel, in fact it's hadrly useful
at
all
if you want to go beyond simple summations etc.

--


Regards,


Peo Sjoblom




"Terry" wrote in message
...
Unsure where to get help with Excel Mobile (5).

I am using my PDA and wish to enable/install the "randbetween"
function.
in a spreadsheet.

Can someone direct me to a forum or newsgroup please?

TIA

Terry