How to generate random numbers in Excel with no repeats - Ablebits.com
https://www.ablebits.com/office-addins-blog/generate-random-numbers-excel-no-repeats/
WebNov 15, 2022 · To generate random numbers in Excel without duplicates, use one of the below generic formulas. Random integers: INDEX (UNIQUE (RANDARRAY ( n ^2, 1, min, max, TRUE)), SEQUENCE ( n )) Random decimals: INDEX (UNIQUE (RANDARRAY ( n ^2, 1, min, max, FALSE)), SEQUENCE ( n )) Where: N is the number of values to generate. …
DA: 88 PA: 49 MOZ Rank: 75