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

S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Findiing highest and lowest in rows and columns 3
Trying to find additional ranges outside of min, max, and average 2
How to find highest, lowest and last cell in row? 3
How do I find highest lowest and last cell in a row? 1
Find 2 highest point to form resistance line 8
calculate last 4 data points in a column (with sometimes blank rows) 7
Find 2 lowest point to form a trendline 0
Average of values in row excluding the highest and lowest value? 18

Top