How do I 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
 
J

Jerry W. Lewis

See your other thread in microsoft.public.excel.misc. Please do not
separately post the same question to mulitiple newsgroups.

Jerry
 

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
How to find highest, lowest and last cell in row? 3
How to find highest, lowest and last cell in a row? 1
calculate last 4 data points in a column (with sometimes blank rows) 7
Highlight highest / lowest number in a row 3
How do I record new Highest / Lowest numbers as data changes in ce 3
How do I get Excel to make highest #, 1 color, & lowest # another? 1
HOW TO TOTAL THE THREE HIGHEST AMOUNTS IN A ROW 2

Top