calculate maximum value every nth rows

[MacBranco]

Hi,
Do anyone can tell me how to calculate maximum value every 100th rows and retrive that value in a new sheet?
Thanks
Mbranco

[Pete_UK]

Which column(s) will the numbers be in on Sheet1?

Pete

[MacBranco]

The data is in D column.
Thanks

[Pete_UK]

Here's one way - put this formula in Sheet2:

=MAX(INDIRECT("Sheet1!D"&(ROW(A1)-1)*100+1&":D"&ROW(A1)*100))

then copy down. It will give you the max for rows 1-100, then 101-200, then 201-300 etc.

Hope this helps.

Pete

[MacBranco]

OK, Thanks,
But it work also in a macro?
MBranco

[Pete_UK]

It's a formula - you don't need a macro.

Pete

[MacBranco]

Ok. Thanks