Create 2 new columns after the Rank column. The first one is "Misc Rank" and the second one would be "Total Rank". The "Total Rank" is a calculated field taking the "Rank" and "Misc Rank" fields together. The "Total Rank" field is then used to determine the rank bonus.
Doing this would allow a GM to manually implement Similar Skills section in RMC II.