randbetween number

I need help with the formula for assigning 20 randomized numbers (1-20) that can not repeat. Please help. Thank you!

Pls help me to generate 100 random numbers between 100 and 300 in some range of cells like A1:j10

Hi all, I have 379 sample identities in my Excel spreadsheet in A2:A380. I want to randomly assign a number from 1-5 to each of these. Can anyone recommend the most appropriate way to do this? Thanks!

Hi all, I know how to create a random number between a set of numbers (i.e. =randbetween(1,99999), however, I cannot find a way to have the number "freeze", or hold from regeneration, when I re-open the spreadsheet, press F9, or decide to add another row for a new number to generate. Any ideas...

1st post Im not bad in Excel but having seen some of the moderators answers Im beginning to re-think how good (or not) I am - lol. Having said that I have a real challenge. I trade the markets and I am testing a trading system that I have developed that requires certain conditions be met...

I have created a custom bingo card with random between however it duplicates numbers on some cards. Please let me know what formula you can use to make sure there are no duplicate numbers on each card.

hey guys, here's my question - is there any way of generating random numbers within a set range in ONE cell only without having any repetition until all the numbers have been cycled through once, after which the random selection starts again. I've tried using RANDBETWEEN but whilst this...