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

Document foundation draft

Rentahuman, the ai that hires humans for real-world tasks

All-in-one pc search

Activate tiny 11

Second letter in lowercase by the computer!!!

Is google chrome not responding?

Forced to restart my computer to get internet access

Printer outputs blank sheets

Evolution of the pdf format

Suspicion of fraud