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
Bookmarks