rand

[zezo2021]

is rand generate unique number not repeated also if excel close and reopen again

 

[MajP]

How to Generate Random Numbers in Excel (Without Duplicates)

Learn how to generate unique random numbers in Excel without duplicates using the RANDBETWEEN, RAND, RANK, LARGE, and MATCH functions.

spreadsheetplanet.com

 

[MajP]

Randomize statement (VBA)

Office VBA reference topic

docs.microsoft.com

to get a new pattern on open

 

[The_Doc_Man]

@zezo2021 - Random numbers can repeat very easily. True randomness means there is no selection constraint on the number (though you CAN impose a range constraint).

What is your business need? I.e. tell us what you REALLY want using a description of the BUSINESS rule.