View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
scott scott is offline
external usenet poster
 
Posts: 577
Default listing permutations

Mike,

Thanks this was exactly what I was looking for.

Scott

"Mike H" wrote:

Scot,

Look here
http://www.ozgrid.com/forum/showthread.php?t=28321

Mike

"scott" wrote:

I need to list the possible permutations for 5 numbers using all 5 in each
permutation.

1 2 3 4 5
2 1 3 4 5
1 2 4 3 5
etc.