# Script which sorts the numbers into a growing sequence

## Recommended Posts

Hi!

I would liket to make a script which would generate 5 random number and after it makes them in a growing sequence (for example: number: 3, 8, 7, 10, 6

and than it would make them like 3, 6, 7, 8, 10)

Thank you

##### Share on other sites

Hi!

I would liket to make a script which would generate 5 random number and after it makes them in a growing sequence (for example: number: 3, 8, 7, 10, 6

and than it would make them like 3, 6, 7, 8, 10) and than shows me the sequence in a msgBox

Thank you

Edited by szucsaaron

##### Share on other sites

Hi szucsaaron,

please don't create multiple threads for the same subject. You now have two!

What have you tried so far? Can you post your script?

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:

##### Share on other sites

I am really sorry but the webpage is lagging for me :S

I could not really start the script because i did not have any ideas :S

I could only do this which would generate the 5 numbers but i still dont know how to put them in a sequence :S

```MsgBox(0, "", _Numbers())

Func _Numbers()
Local \$a = Random(1, 100)

Local \$b = Random(1, 100)

Local \$c = Random(1, 100)

Local \$d = Random(1, 100)

Local \$e = Random(1, 100)

EndFunc ;==>_Numbers```

##### Share on other sites

under sequence i mean for example it generates 5 2 4 3 1 and it writes them to a msgBox like 1 2 3 4 5

##### Share on other sites

Format the random numbers as strings e.g. 1 gets 001 and write all the numbers to an array. Then use _ArraySort to sort.

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:

##### Share on other sites

Thank you very much water!

## Create an account or sign in to comment

You need to be a member in order to leave a comment

## Create an account

Sign up for a new account in our community. It's easy!

Register a new account