"Ragdyer" wrote in message
...
Sorry ... forgot how to count!

Use this:

=INDEX(B10:B50,INT(RAND()*41)+1)
--
HTH,

RD


Can you explain the logic behind that?

Why 41?

When I use it in a different range it doesn't work properly.