RANDOM BETWEEN BOUNDS without duplicates

Question

Hello, How can I generate a list of numbers from (for example) 1 to 15 without any duplicates? Thank you for your responses Best regards Soubisien Configuration: Windows / Firefox 50.0

yclik · Accepted Answer

Hello See there with macro replace 7 with 15 and 49 with 15

soubisien85 · Answer

I don't see "form design" Is there no formula in addition to the bound randomness that could help me? Thank you Best regards Soubisien85

yclik · Answer

Re
The only formula does not eliminate duplicates; a macro is needed.
The hidden sheet is unnecessary and can be deleted.
Format>sheet...>Show
then delete the sheet

in the macro modify
oSheet = ThisComponent.Sheets(1) replace 1 with 0

to display the macro
ALT+F11
search for the workbook in the tree and select it
+Standard
-- module 1
"Edit" button

to create a button
View>toolbar>Form control
Activate the form draft via the square icon

Draw a button with the "Button" tool

assign a macro
Once drawn
Select it
right click>Control>Tab "Event"
Select "Run action"
"macro" button
select the macro:

search for the workbook in the tree and select it
+Standard
-- module 1
select "Drawing"
and "OK" button
"OK" button

cancel the form draft via the square icon

soubisien85 · Answer

Thank you for everything! Best regards Soubisien

RANDOM BETWEEN BOUNDS without duplicates

4 answers

Site unreachable

Reinstallation of w11 impossible after pc crash...

Nonexistent sent items folder

Transfer mp3 from pc to mobile

Increase the capacity of free's zimbra webmail to 10gb

Unrefreshed usb drive on android interface

Tencent impossible to remove

Is there enough storage space on my vps?

Car gps tracker

Erreur de captcha