Permutations function for musical notes

THREAD SOLVED...and very well too

Hi All,

I saw a few posts on permutations/combinations functions and pointers to the Myrna Larson toolkit/workbook but I think my need is slightly different from that use case (maybe not!)

I need to find all 3, 4 and 5 letter permutations based on 5-8 musical notes as input. FYI the permutations will be chords.

i.e. C, D, E, F, Ab, Bb, B as an input musical scale input would yield

All three note combos :
C,D,E
C,D,F
C, D, Ab
....
all 4 note combos
C,D,E,F
C,D,E,Ab

all 5 note combos
C,D,E,F,Ab
C,D,E,F,Bb
...

I'd like to structure the sheet as having 12 columns (1 for each note within an octave) with the combo placed under the right column i.e. C goes in 1, Eb in 4.

any help on this matter much appreciated

Drongomala