Need Random number generator formula

neil_c

New Member
Joined
Mar 6, 2021
Messages
13
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Hi, I want to generate 20 random numbers between 1-80, but my formula always bringing duplicates also. So is there any way to generate 20 sorted numbers in ascending order without duplicates and I want to save those numbers at runtime. it will be easy if the formula can generate numbers for 100 rows.
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

neil_c

New Member
Joined
Mar 6, 2021
Messages
13
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
You can Copy it and Paste Value
YES, this is what I thought to do. just a quick question: can I add the number of lines command to the formula so that I don't have to copy and drag down. so it can automatically generate numbers up to a given specific line number.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,383
Messages
5,635,977
Members
416,890
Latest member
blader1989

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