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

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

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:CF1 0))
Also see: http://www.xldynamic.com/source/xld.LastValue.html


--
Regards
Frank Kabel
Frankfurt, Germany

"Sam" schrieb im Newsbeitrag
...
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

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

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