Get all possible permutations

[Rahulwork]

Hello Team,

I want to make all possible permutations of a name.

I have a name like X Y Z and i have separate this name on the basis of space so now I have

A1 - X
B1 - Y
C1 - Z

In D1 I want to get all possible permutation of X Y Z for example X Y Z or Y X Z or Z X Y and so on.. or should be there to differentiate.. pls help.

Thanks

 

[motilulla]

Hello Team,

I want to make all possible permutations of a name.

I have a name like X Y Z and i have separate this name on the basis of space so now I have

A1 - X
B1 - Y
C1 - Z

In D1 I want to get all possible permutation of X Y Z for example X Y Z or Y X Z or Z X Y and so on.. or should be there to differentiate.. pls help.

Thanks

Hello Rahulwork , in that case I will suggest you to use pgc01 code under this link you will find your answer sure</SPAN></SPAN>

https://www.mrexcel.com/forum/excel-...ml#post1424848

and may be here

https://www.mrexcel.com/forum/excel...st-all-possible-permutations.html#post4598765

Regards,</SPAN></SPAN>
Moti</SPAN></SPAN>