Picking up the last 10 entries which are spread out

[khank]

I've been using the following formula as an array (see column E of my sample):

{=IF(ROWS($E$3:$E3)>MATCH(REPT("Z",255),$A$3:$A$2901),"",INDEX($A$3:$A$2901,MATCH(REPT("Z",255),$A$3:$A$2901)-MIN(10,MATCH(REPT("Z",255),$A$3:$A$2901))+ROWS($E$3:$E3)))} and it works great!

I've been trying to use this formula to pickup the last 10 entries which are spread out every 7 cells in columns B and C (see FORUM SAMPLE 6) and getting a return of #NA –

Is there a formula or how could I modify the one I'm using that would pick up the last 10 equally spread out every 7 cells?