Random Text

[Pigeon]

Dear Members

I registered today and this is my first post in the forum.

if cell A1 to A5 contains fruits like banana, apple, grapes, guava, melon.

and in cell A6 i want a random fruit from above 5 fruits, then what formula shall i use?

Regards
Pigeon
INDIA

 

[Aladin Akyurek]

You could try...

=INDEX($A$1:$A$5,RANDBETWEEN(1,ROWS($A$1:$A$5))