View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Max
 
Posts: n/a
Default =combin function

You might also want to try this recent response to a similar query:
http://tinyurl.com/nbdhx
(Link to a sample file with Myrna Larson's power subroutine, ready to play)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jerry Kinder" wrote in message
...
Hi,
I want to know the combinations of four letter that are possible from a

list
( abcdefghij ) .
The =combin function will tell me how many combinations are possible.
=combin(10,4)
I want a list of all the possible combinations of 4 letters for the list.
abcd
acbd
addc .... etc.
Is there away to have excel 2000 do this??

Thank you,
Jerry