Highest A11=max(M10:CF10)
Lowest A12=min(M10:CF10)
I did not undersatnd what you mean by 'last cell in a row'. do you mean
last filled cell?

"Sam" wrote:

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