IF Formulas to Find a Non-Empty Cell and Return Value in Range

K

Kerrick Sawyers

Hi everyone! I received the following response to my
question, however the formula is not working for me. The
cells that I need to identify all begin with a number,
don't know if that makes a difference. Please help.
Thanks again:

Tony
=OFFSET(A1,MAX((A1:H8<>"""--""")*(ROW(A1:H8)))-1,MAX
((INDIRECT("a"&MAX((A1:H8<>"""--""")*(ROW(A1:H8)))&":h"&MAX
((A1:H8<>"""--""")*(ROW(A1:H8))))<>"""--""")*COLUMN(A:H))-
1)




Hello everyone!

I am hoping that someone can help me out here. I am
looking for an IF formula that will allow me to search a
specified range for data that does not = "--" and then
return that value in a specified cell. Does anyone know
of a way to do this. I have tried numerous conditional
formulas that will only return a value for two columns.
The range I am working with is actually 8 columns wide.
Thanks in advance for any help that you might be able to
give me. Take care.

Kindest regards,

Kerrick Sawyers
GE Healthcare
 

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

AVG or Return 1 value from either of 2 cells if one is blank 8
Copy addition formula of non-consecutive horizontal cells 2
IF Formulas to Find a Non-Empty Cell in a Range 0
Combination of IF, AND, and COUNTIF; need help 6
Need help with a formula 3
Formula Help-returning False 3
If statements 4
Combining two formulas 0

Top