Get instant live expert help on randbetween 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 have two columns in Excel when I select remove duplicates it says no duplicates but there are approx. 3100
Solved by M. H. in 15 mins
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 have 19237 cell with duplicates number how to change them to some other number so that there is no duplicates at all i will attach it on the spreadsheet
Solved by V. J. in 26 mins
#ref! with this formula: =INDEX(A7:A106,RANDBETWEEN(7,106))
Solved by M. H. in 12 mins
2. Now use the RANDBETWEEN function in Microsoft Excel to select three simple random samples of 10, 50 and 500 days from the population
Solved by G. H. in 17 mins