Skip formula and some powerpoint

[Martines91]

So what I need to do in excel is that I have values in cell E13 that was before and in E14 after, in E15 is the difference formula "=ABS(E13-E14)" and now I need to set a MAX value in E1 that will find the MAX value in every 3rd cell from E13, e.g. E13, E16, E19, E22 etc. until E610

if someone could give me the formula to make that and tell me how it works then I could do the rest.

Second thing is that I added the excel sheet in powerpoint, as a working source, and what I need to set is that e.g. now I have a range of 10 rows and I want to set it that when I reach the 10th row and I want to continue lower so when I scroll to a range of 12-22, thing is whenever I scroll down and leave the window it gets back to 1-10 instead for example 12-22, hope you understand, thanks

[Special-K]

in E1
=MAX(IF(MOD(ROW(E13:E610),3)=1,E13:E610))
Array formula, use Ctrl-Shift-Enter

[Martines91]

in E1
=MAX(IF(MOD(ROW(E13:E610),3)=1,E13:E610))
Array formula, use Ctrl-Shift-Enter

thanks! it worked but it somehow doesn't if I want then E14, E17, E20, E23 etc. until E611, in E4. I somehow don't understand how the formula works.. also what is ctrl-shift-enter supposed to do? and still how can I set to show a particular section of an excel in powerpoint without it returning it back? thanks

[Martines91]

anyone? please?