Suppose you have headings in Row 2 (K2=HEADING) and Formula in Row 1 (K1=FORMULA) ......
K1 = MAX(IF(MOD(ROW($K$3:$K$65536)+94,96)=0,$K$3:$K$65536,0))
Now before quiting the cell Press Ctrl+Shift+Enter. {} will come around formula this is called array formula
don't try to manual enter {} brackets ......... Now this formula will look every 96th row ..... you can try ....
if you need any further clarification don't hesitate to contact me .....