Re: $$Excel-Macros$$ Excel Formula. Seems simples but i can't figure out how to do it

You can also try this non array formula.. =INDEX(C4:I4,MATCH(TRUE,INDEX((C4:I4<>0),0),0)) Cheers!! On Fri, Mar 13, 2015 at 8:49 PM, André D'Avila wrote: > Thank you very much > > André Luiz D´Avila > > 2015-03-13 12:13 GMT-03:00 Vaibhav Joshi : > > Check formula in col k.. >> >> Cheers!! >

Re: $$Excel-Macros$$ Excel Formula. Seems simples but i can't figure out how to do it

Hi André D'Avila, Please try this formula "=INDEX(C2:I2,MATCH(1,INDEX(ISNUMBER(C2:I2)+0,0),0))" in cell J2 and also find the attached file. Regards, MV On Fri, Mar 13, 2015 at 8:04 PM, André D'Avila wrote: > Dear experts, > > I can't figure out how to create a fórmula to this problem. > > In t

Re: $$Excel-Macros$$ Excel Formula. Seems simples but i can't figure out how to do it

Thank you very much André Luiz D´Avila 2015-03-13 12:13 GMT-03:00 Vaibhav Joshi : > Check formula in col k.. > > Cheers!! > > On Fri, Mar 13, 2015 at 8:04 PM, André D'Avila > wrote: > >> Dear experts, >> >> I can't figure out how to create a fórmula to this problem. >> >> In the first hand

Re: $$Excel-Macros$$ Excel Formula. Seems simples but i can't figure out how to do it

Check formula in col k.. Cheers!! On Fri, Mar 13, 2015 at 8:04 PM, André D'Avila wrote: > Dear experts, > > I can't figure out how to create a fórmula to this problem. > > In the first hand seems simples, but i couldn't sove without creating a > excel macro. > > Is it possible to create a fórmu

$$Excel-Macros$$ Excel Formula. Seems simples but i can't figure out how to do it

Dear experts, I can't figure out how to create a fórmula to this problem. In the first hand seems simples, but i couldn't sove without creating a excel macro. Is it possible to create a fórmula to the challenge bellow? I attached the file too. Thx. André Luiz D´Avila [image: Imagem inline 1]