pull from a list, randomly?

[lpking2005]

hi,

I have some slogans in a column on sheet2,

On Sheet1, i want to be able to randomly pull from the slogans in sheet2 into a cell on sheet1.

I currently have this formula in the cell on sheet1, but still nothing is working!?

=INDEX(slogans!A2:A24,RAND()*100+1)

Any help would be much appreciated. thanks.

 

[Phanmore]

=INDEX(slogans!A2:A24,RAND()*24)

 

[lpking2005]

thanks for reply, this worked in a certain way,

it only pulls across numbers but not a sentence of words

 

[Phanmore]

I've tested this and it seems to work fine in Excel 2003.

All I can suggest is that you ensure the information you are trying to pull through is in cells A2:A24, if not, change the range.

 

[Ruddles]

Works here in Excel 2007.

 

[scottylad2]

hi,

I have some slogans in a column on sheet2,

On Sheet1, i want to be able to randomly pull from the slogans in sheet2 into a cell on sheet1.

I currently have this formula in the cell on sheet1, but still nothing is working!?

=INDEX(slogans!A2:A24,RAND()*100+1)

Any help would be much appreciated. thanks.

Try INDEX(slogans!A2:A24,Randbetween(1,23))