Ask Experts Questions for FREE Help !
Ask
    shiv94's Avatar
    shiv94 Posts: 5, Reputation: 1
    New Member
    		  
    #1

    Mar 6, 2007, 12:31 PM
    Excel randbetween
    Well I no how to use randbetwenn with numbers but I have some words in different cells is there anyway I can do a randbetween with those
    Thanks
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Mar 6, 2007, 12:36 PM
    Nope, RandBetween takes only numeric values as its parameters. What is it you are trying to accomplish?
    cajalat's Avatar
    cajalat Posts: 469, Reputation: 66
    Full Member
    		  
    #3

    Mar 6, 2007, 09:01 PM
    ScottGem is right... there is no single function that will do what you're asking. However, you can probably make use of the randbetween function in an indirect way to get what you want. For example:

    Code:
    =CHOOSE(RANDBETWEEN(1,4),A11,A12,A13,A14)
    This will randomly choose the value of some given cells. The limit of the "CHOOSE" function is 29 cells.
    Ken Hackney's Avatar
    Ken Hackney Posts: 1, Reputation: 2
    New Member
    		  
    #4

    Mar 19, 2007, 10:35 AM
    Use

    =INDEX($A1:$A10,RANDBETWEEN(1,COUNTA($A1:$A10)),1)

    for randomly choosing a word from columns A1-A10. Of course, you can change this to any rows or columns you need. Just change the formula accordingly.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How to get better with Excel [ 2 Answers ]

My Vietnamese staff and I use Excel all the time, but we're limited to very basic stuff. Can anyone recommend an easy and comprehensive how-to reference, either book form (which we would have to order by mail) or on-line info? Thanks. -- Chuck Searcy, Hanoi

Excel [ 2 Answers ]

:rolleyes: I try to use excel to print an invoice, how can I put an invoice number that will auto upadate the next time I use the file?

Excel help [ 1 Answers ]

I am using excel to record some data and I have it setup to do some math based on the info that I put into certain cells. Now what I am wondering is am I able to setup the sheet so that it will prompt me for the 4 pieces of data that I want to enter and then place those in the proper cells and then...

Access and Excel [ 1 Answers ]

Is it possible to import simple information from a spreadsheet in Excel into a pre-existing Access table? If so, how?

View more questions Search