Help with finding highest value in a range

Hi. I had to delete a couple of empty rows to make it easier...

If that's it, can you mark the thread as closed and (preferably) click the Add Reputation button at the foot of this post.

Another way..

In Glenn's sheet
=MAX(OFFSET(INDEX(C:C,5*(ROWS($A$1:A1)-1)+2),,,5))

Copy down

Another way.....

Assuming the value col. starts from C2

Please Login or Register  to view this content.

Or Considering your sample sheet in post#1, try this in I4

Please Login or Register  to view this content.

@Ace_XL
Sorry. I didn't check the replies before posting. You already posted the same formula. I should have checked that before posting my reply.

But my formula slightly differs from yours.

If that's it, can you mark the thread as solved and (preferably) click the Add Reputation buttons at the foot of the post(s) of those who helped..

Cheers, Kochark.