Any Excel wizards???

Hooked

Howdy all

I'm trying to generate a number sequence in Excel (I'm a graphic designer) so that I can generate 720 results for possible race finish of 6 greyhounds.

ie
123456
123465
123564
123546

and so on...
6x5x4x3x2x1 = 720 variables

I'm relatively familiar with Excel as we use it for mail merging, personalising data and writing numbering blocks for tickets, docket books, etc... but these are usually in sequence.

This one has me stumped!

Fysh

There's a thread here for a similar query (only with more total possible combinations) that should hopefully cover you. The first page has two versions of a macro that should give you the general solution, the first post on the second page has comments to explain what the code does in case you need help understanding what to change.

Hooked

Thanks Fysh... I'm more a software using designer than "coding" guru - but I'll see if I can wrap my head around that "macro".

Thanks

Fenster

Seems like a straight permutation problem.