3-pair Permutation / Combinations from a single list of seven (7) inputs

[fastwriter]

Hey gang!

Hope you are all well!

So I've been scouring the 'net for this answer and can't quite find the *exact* formula for this. Hoping I can solve this in Excel w/out VBA. The simpler, the better.

I am trying to generate a permutation list of 2-char pairs and generate a non-repeating list of three (3) combinations from the following:

- Sa
- Ur
- No
- Ma
- Ha
- Ju
- Mo

From the above list, I'd like to get a combination with only 3 of the above at time, with no repeats.

Example:
- Sa Ur No
- Sa Ur Ma
- Sa Ur Ha
- Sa Ur Ju
- Sa Ur Mo


-- Is there a simple way to do this in Excel?

Looking forward to your responses!

 

[Fluff]

Why not update it now, whilst you think of it?