randbetween number

  1. A

    Randbetween

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

    randbetween

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

    Using the RAND function

    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!
  4. M

    Random Number Without Regeneration

    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...
  5. A

    This is a serious challenge

    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...
  6. L

    Bingo Card

    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.
  7. L

    Random Number Generation without Repetition?

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top