Hi Frank

Thanks for your wonderfully fast and helpful response.

It's much appreciated.

Sam

"Sam" wrote in message
...
Hi

I'm having trouble trying to find an excel function that will let me
return the highest, lowest and last cell in a row of cells spanning
M10..CF10 (60 cells).

All the consecutive cells will have a value, but the row will only be
partially full with some number of still empty cells at the end.

Is there someone who knows how I can solve this problem. Thanks for your
kind help.

Please reply to the newsgroup as my email address is false to avoid spam.

Thanks again
Sam