Choosing randomly from a list

[Coffin_joe46]

Hi,

I am trying to set up something in excel so I can randomly choose something from a list. At the moment I am using the formula:

=INDEX($A:$A,RANDBETWEEN(1,COUNTA($A:$A)),1)

I know this works if its in column A. If the list was in column A of Sheet 1, how would I make it work if I wanted the random thing to appear in Sheet 2 somewhere.

Thanks,

Andrew

 

[PaddyD]

hi - welcome to the board!

=INDEX(sheet1!$A:$A,RANDBETWEEN(1,COUNTA(sheet1!$A:$A)),1)

..in general, you can use your mouse to select the ranges you need in a formula & excel will do the writing for you.

 

[Coffin_joe46]

Thanks!!!