need formula help

D

DebC

=IF(C26="",C24,C26)
The formula above is entered into cell C27

I need a formula that will allow me to take it further,
that if both C26 and C24 are blank or zero, then C22
or if C22 is also blank or zero then C20, and so forth

Thanks in advance for any help!
 
L

Luke M

You could try this array* formula. Adjust smaller range sizes as necessary
(do not adjust the column reference):

=INDEX(C:C,MAX(IF((MOD(ROW(C1:C26),2)=0)*
(C1:C26<>0),ROW(C1:C26))))

*Confirm formula using Ctrl+Shift+Enter, not just Enter.
 
D

DebC

Wow! This worked great. Thank you so much. I admit I do not understand the
formula; I thought it would only grab the max value, which would not have
worked for this situation. Thanks again.
 

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

Top