What is the function?

Question

I am looking, if possible, for a function that takes a name from a list and assigns it to 1 of two roles at random

Answer 1

Hi OBIE

I'm Anna and I'd be happy to help you with your question. In this Forum, we are Microsoft consumers just like yourself.

How to select a random value from a list

Supposing you have a list of names in cells A2:A10 and you want to randomly select one name from the list. This can be done by using one of the following formulas:

=INDEX($A$2:$A$10,RANDBETWEEN(1,COUNTA($A$2:$A$10)),1)

or

=INDEX($A$2:$A$10,RANDBETWEEN(1,ROWS($A$2:$A$10)),1)

That's it! Your random name picker for Excel is all set up and ready to serve:

Reference: https://www.ablebits.com/office-addins-blog/excel-random-selection-sample/

Note: This is a non-Microsoft website. The page seems to provide accurate and reliable information. Beware of advertisements on the site that may advertise products frequently classified as PUPs (potentially unwanted products). Do thorough research on any product advertised on the site before downloading and installing it.

I hope this helps ;-), let me know if this is contrary to what you need, I would still be helpful to answer more of your questions.

Best Regards,

Anna

Give back to the community. Help the next person with this problem by indicating whether this answer solved your problem. Click Yes or No at the bottom.

Answer 2

Thank you very much Anna