Generate number based on given numbers with no duplicate

[jamshoot]

Hi all

Seek help.
Is there a formula to self generate numbers with a given number with no duplicate.
Example:
In A1, I have 1234.
What formula to use to generate number in a column B1, a series of numbers based on A1 (1234) until there is no repeat.
cheers

 

[GazNicki]

Hi Jamshoot.

Not sure what you want exactly from this.

Are you looking to use the numbers 1 2 3 4, so see how many different combinations of numbers you can get from those 4 digits, without repeating?

So:
1234
1324
1432
2134

and so on?

 

[jamshoot]

Hi Jamshoot.

Not sure what you want exactly from this.

Are you looking to use the numbers 1 2 3 4, so see how many different combinations of numbers you can get from those 4 digits, without repeating?

So:
1234
1324
1432
2134

and so on?

Hi there

That's correct.
cheer

 

[jamshoot]

Hi there

That's correct.
cheer

Hi there,

Any solutions for me.
Cheers