IF Formulas to Find a Non-Empty Cell in a Range

K

Kerrick Sawyers

Thanks! However, I get an error message - Probably my own
fault, I forgot that each cell actually begins with the
number 0 even though it is formatted as text. Any ideas
on how to fix this? Thanks! :)

Regards,

Kerrick

-----Original Message-----
Kerrick

This may seem convoluted but if you have the data in the
Click to expand...
range A1:H8, then array enter (shift, ctrl, enter) the
following formula into the required output cell. Worked
with the data I tested. Modify the range as required.
Tony
=OFFSET(A1,MAX((A1:H8<>"""--""")*(ROW(A1:H8)))-1,MAX
Click to expand...
((INDIRECT("a"&MAX((A1:H8<>"""--""")*(ROW(A1:H8)))&":h"&MAX
 

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

IF Formulas to Find a Non-Empty Cell and Return Value in Range 0
Copy addition formula of non-consecutive horizontal cells 2
Combining two formulas 0
Formula help please 1
Array formula returns blank in the cell where it is entered 1
Trying to find additional ranges outside of min, max, and average 2
Excel Formula Error for No Good Reason 4
Error when insering a "Right" function 1

Top