View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default listing permutations

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.