Thanks Pete

David

On Oct 2, 8:46 am, Pete_UK wrote:
Try this:

=MAX(C5,E5,G5)

Hope this helps.

Pete

On Oct 2, 9:18 am, david wrote:





I want to find the maximum over a non continuous range of cells. I
know how to do it if they are continuous but I don't if they are not.

For instance I want to find the maximum of the values in C5 E5 & G5
but ignore the intervening cells

Help greatly appreciated.

Thanks

David- Hide quoted text -

- Show quoted text -