View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default Please help - Permutations of words

Hi!

I just ran Myrna's procedure on your data and it produced:

Permutations: 6/2 = 30
Combinations: 6/2 = 15

You must be doing something wrong.

Want to see the file?

Biff

"JE" wrote in message
...
Question:
I have 6 words and I'd like to see all of the possible combinations in
which
they can occur for example - it - and - the - but - blue - yet. I've been
through the posts and Myrna Larson's download doesn't work for me - I keep
getting error messages with the values - is there a regular function in
Excel
that will show me the combinations? If not - how can I do this? eg. I want
to
see the permutations like the ones below etc... Thank you
the and
and the
but yet
yet but