ranbetween

[jkf]

hi all

can I use this command for words instead of numbers

I want to us a group of 8 but instead of numbers I would like to use

70's
80's
groups
soloists
albums
singles
American
coke

as you may of guessed it is for a game

tia

john

 

[Ron Rosenfeld]

hi all

can I use this command for words instead of numbers

I want to us a group of 8 but instead of numbers I would like to use

70's
80's
groups
soloists
albums
singles
American
coke

as you may of guessed it is for a game

tia

john

With your list of words in J1:J8

=INDEX($J$1:$J$8,RANDBETWEEN(1,8))

 

[jkf]

Thanks a lot Ron works a treat, (sorry for posting in other group, I truly
didn't know it was not aloud)

thanks again

John

 

[Kevin@Radstock]

hi all

can I use this command for words instead of numbers

I want to us a group of 8 but instead of numbers I would like to use

70's
80's
groups
soloists
albums
singles
American
coke

as you may of guessed it is for a game

tia

john

Or: =CHOOSE(RANDBETWEEN(1,8),"70's","80's","groups","soloists","albums","singles","American","coke")

 

[Ron Rosenfeld]

Thanks a lot Ron works a treat, (sorry for posting in other group, I truly
didn't know it was not aloud)

thanks again

John

Glad to help.
It seems nothing on Usenet is "not allowed". It's just that multi-posting (posting the same message to multiple groups separately) divides the attention and resources of those who might respond. There is a method of doing this, called "cross posting". If you post to multiple groups simultaneously, by having all the different group names in your message header (e.g. one post, multiple addresses), many (but not all) news services and news readers can detect that and can also respond to the message in all the newsgroups simultaneously.

So, if you feel you need to post the same thing to multiple groups, do it all from a single message. i.e. cross post rather than multipost.