take the content from 7 cells randomly

[0103media]

hi all,

I need to add in to my present formula a random word from a list of
word all held on cells L1 to L7

Kind anyone help pls....


Kind regards

g



'web design london' (http://www.0103media.co.uk)
'search enigne optimisation uk' (http://www.0103media.co.uk

 

[JE McGimpsey]

One way:

=INDEX(L1:L7,RAND()*7+1)