Re: $$Excel-Macros$$ Help Formula to find last date please

Or a non-array formula =LOOKUP(2,1/(C3:Z3<>0),$C$2:$Z$2) Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick atte

Re: $$Excel-Macros$$ Help Formula to find last date please

Dear marcio, You can also use.. =INDEX($2:$2,0,LARGE(IF(C3:Z3>0,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/* On Mon, M

Re: $$Excel-Macros$$ Help Formula to find last date please

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: