need formula help

  • Thread starter Thread starter DebC
  • Start date Start date
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!
 
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.
 
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.
 
Back
Top