IF key of C has notes CDEFGABCDEFGABC progression, then notes
1-2-3-4 : 2-3-4-5 : 3-4-5-6 will result in C D E F D E F G E F G A respectively
I want to create note patterns regardless of scale type: Major, minor, modal etc in each of 12 keys. Music software exists but simple EXCEL formulas should be available or easily created.
Create a table that has the key name in column A, and in column B the letter for a 1, etc. like
Major C C D E F G H A B
Name that sheet "Keys"
Then use a formula like this
=OFFSET(INDEX(Keys!$A:$A,MATCH($A4,Keys!$A:$A,FALSE),1),0,B4)
Where A4 has the name of the key you are using, and B4 has the number you want to convert to a note. You can copy this formula to the right for a far as you need.
Bernie Deitrick
Excel MVP 2000-2010
Bernie: THANKYOUVERYMUCH!! will work on it this weekend.
jjsaspo (Joe Saporito)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks