Formulas

Hi Galina

Thank you for a question. How about

=RANDBETWEEN(1,50)

Where 1 is the starting figure and 50 is the maximum - change the max to suit your requirements.

This could then be combined with the Index function:

=index(array,randbetween(1,10))

where array is a column of 10 cells that contain the text items
to be selected.

If you press F9 this will force Excel to refresh its random number and you will see a different item selected from your list.

I hope this helps - let me know how you get on.


Kind regards,
Andrew