Dear marcio,
You can also use..
=INDEX($2:$2,0,LARGE(IF(C3:Z30,COLUMN($C$2:$Z$2),),COLUMN(A2)))
with ctrl+shift+enter
See attached sheet.
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
On Mon, Mar
Hi Marcio,
It has been done using Excel formula, see the attachment and let me know if
this is what you were looking for.
Feel free to get back in case of any queries. Thanks.
Regards,
DILIPandey
On Mon, Mar 12, 2012 at 6:53 AM, Marcio Bandeira de Azevedo
marciobandeir...@gmail.com wrote: