Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel mobile help please
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel mobile help please
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel mobile help please
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel mobile help please
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel mobile help please
Yesssssss..that helps, thank you....good work.
Now allow me to explain why I need this function. On coach trip I have bingo games whilst travelling, normally using small bingo numbered discs, which roll about on coach, & difficult to stabilise. What I have thought about is to use my PDA as above (1 to 90), randomly.(much easier). Really now I need to "recall/save/record" those random numbers for checking back when house called if possible !!!! 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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel mobile help please
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel mobile help please
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Mobile ? | New Users to Excel | |||
Excel Mobile and VBA? | Excel Discussion (Misc queries) | |||
Time Stamp in Excel Mobile, Windows Mobile 5.0 | Excel Discussion (Misc queries) | |||
Excel Mobile | Setting up and Configuration of Excel | |||
excel mobile notes | Excel Discussion (Misc queries) |