How to find highest, lowest and last cell in row?

[Sam]

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

 

[Frank Kabel]

Hi
1. Min value: MIN(M10:CF10)
2. Max value: MAX(M10:CF10)
3. Last value (if you only have numeric values):
=INDEX(M10:CF10,MATCH(9.99999999999999E307,M10:CF10))
Also see: http://www.xldynamic.com/source/xld.LastValue.html

 

[Vikrant Vaidya]

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]

Hi Frank

Thanks for your wonderfully fast and helpful response.

It's much appreciated.

Sam