Jump to content

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)

Please reply!

Thank you

Share this post

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

Please reply!

Thank you

Edited by szucsaaron

Share this post

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-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

Share this post

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 this post

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 this post

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-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

Share this post

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

Sign in

Already have an account? Sign in here.

Sign In Now

×

• Wiki