Big Formula "needed"

[Felix]

I need a formula which could read consecutive cells, disregarding those =0 and using the first cell that is not equal to zero. LOL What a mess!!! Please help.

 

[KenU]

Felix,

The formula below will work with your present layout.
=INDEX($C$4:$I$4,,COUNTA($3:$3)-2)

Hope that helps.

Regards,
Ken

 

[Somendra Misra]

Hi,

See the file. I had also amended your row 4 formula.

Regards,

 

[Felix]

Thank you so much Somendra. You guys are awesome. This is exactly what I was looking for, and thanks for shortening my formula as well. This is a big project and I have learned little by little. From now on I won't go anywhere, but HERE!!!!

 

[Felix]

I must be doing something wrong because it is not working for me. What am I doing wrong?

 

[Haseeb A]

Hello Felix,

That is Array Formula. must be confirmed with CTRL+SHIFT+ENTER. Do not enter manually those braces. This will be automatically inserted when you press CTRL+SHIFT+ENTER.

Remove {} starting & ending in B9, then press CTRL+SHIFT+ENTER

If you are looking to return LAST NON ZERO value, then try this formula with just ENTER.

=1/LOOKUP(2,1/(C7:AG7))

 

[Felix]

Thank you very much Haseeb. All of you are awesome. I think maybe Somendra thought I knew the CTRL+SHIFT+ENTER.

 

[Somendra Misra]

@Felix

Glad you solve it, and I did thought that you must be aware about Array formula's, if you not than please visit below link:

http://chandoo.org/wp/tag/array-formulas/

@Haseeb A Thanks for the back-up.

Regards,