Show randomly a value from the list

A

Amit Sony

I have a list of names of my colleagues, m trying to show the name
randomly from this list without duplication. I've make my own formula
to show this but m not able to stop the duplicity.

Any kind of help on this will be appreciated, even solution is in VBA
or excel format.
 
J

Jim Cone

How do you know which names have been selected previously?
Is there a separate list of previously selected names?


"Amit Sony" <[email protected]>
wrote in message
news:025a1c65-4f37-45bc-8dd9-42f0268137c6@m10g2000pbk.googlegroups.com...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list from index/match formula 1
Assign from a list of names randomly 3
Help with randomly displaying values from a list. 1
how to stop the Web and Reviewing Toolbars from randomly beingdisplayed 1
data validation list 17
Selecting from a randomized list 7
Randomly Select from a list 4
Scrabble Value calculation for Welsh words 0

Top