logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Insert Unique Random Numbers

ASAP Utilities  › Numbers & Dates  ›  14. Insert Unique Random Numbers

This tool fills the selected cells with unique random whole numbers. Each number appears only once, so there are no duplicates.
The smallest number is always 1, and the largest equals the total number of selected cells. For example, if you select 100 cells, the tool will insert a shuffled list of numbers from 1 to 100. Each number is used exactly once. This is useful when you want to:
  • Assign unique IDs in random order
  • Create random rankings
  • Randomize participants in a fair, reproducible way Tip: To quickly shuffle a list or range in random order, use our "Advanced Sorting..." tool and choose the random sort option. It's easier than generating random numbers and sorting manually. Note: Unlike Excel's RAND() or RANDBETWEEN() functions, this tool creates unique fixed values that don't change when the worksheet recalculates. This is helpful when reproducible results are needed, such as assigning participant IDs or generating stable randomized datasets.

    Screenshots

    Numbers & Dates  ›  14 Insert Unique Random Numbers

    Starting this tool


    Numbers & Dates  ›  14 Insert Unique Random Numbers
    Additional keywords for this tool:
    Insert unique random numbers in Excel, Generate random numbers without duplicates, Random number generator no duplicates, Fill cells with unique random numbers, Create random rankings, Assign random unique IDs, Randomize participant numbers, Shuffle numbers without repetition, Fill cells with shuffled numbers, Generate stable random numbers, Random integer list without repeats, Unique randomizer, Create randomized dataset, Number cells randomly without repeats, Fill selection with non-repeating random numbers, Fixed random values, Assign random row numbers



  • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
    For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.