Yes, in the example, I will only have 6 total entries at any given time. Since we are collecting scores, think of a competitive season having 6 matches where we start with Jan, then Feb, and so on.

When we start the year at the first month, the spreadsheet score entries are:
Col_A_____Col_B______Col_C_______Col_D_______Col_E______Col_F
Most Recent Event Date: 01/01/10
01/1/10____02/1/10____03/1/10______04/1/10_____05/01/10____06/01/10
355_______0_________0____________0_________0___________0

As we get to the 5th month, the spreadsheet score entries are:
Col_A_____Col_B______Col_C_______Col_D_______Col_E______Col_F
Most Recent Event Date: 05/01/10
01/1/10____02/1/10____03/1/10______04/1/10_____05/01/10____06/01/10
355_______420________405_________257_________330________0

Thus we are looking to calculate the top 4 scores excluding the 05/01/10 entry at month 5.

As we get to the 6th month, the spreadsheet score entries are:
Col_A_____Col_B______Col_C_______Col_D_______Col_E______Col_F
Most Recent Event Date: 06/01/10
01/1/10____02/1/10____03/1/10______04/1/10_____05/01/10____06/01/10
355_______420________405_________257_________330________415

Once the 6th match event occurs, we are needing the same top 4 scores but excluding the 6th data entry.

This allows me to look at the ranking before the last match (which is what I can't calculate) with the current ranking (which I am already calculating).

Make sense?