Get instant live expert help on I need help with excel random selection from list no duplicates

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I need to extract a unique list from a lookup value that HAS duplicates and i need the extracted values to have no duplicates
Solved by C. S. in 26 mins
I need a formula to get a random value from duplicates names
Solved by G. U. in 13 mins
Trying to figure out what formula to help me with this problem... I have 2 columns both are a list of names first one is just all the names no duplicates 2 column is a list of names with duplicates. I am trying to remove all duplicates from the 2nd column that match the 1st column and save those on a different tab???
Solved by D. W. in 30 mins
I NEED TO PRODUCE A RANDOM SAMPLE SELECTION OF 50 RESPONDENTS THAT WILL REPRESENT A POPULATION OF 500 INDIVIDUALS
Solved by E. U. in 12 mins
I have a list of random generated numbers from 1 through 100. I need a formula that will list the number of instances for each number 1 through 100. For example: My list generates 1000 random generated numbers between 1 and 100. I want to know how many times the number 50 is resulted from the 1000 random generated numbers.
Solved by V. D. in 13 mins