Re: $$Excel-Macros$$ Formula for Last Leave Date

2010-09-15 Thread Nalini P
Thanks Sir, problem solved ...though the array seems complex for me to understand... Salute to Excel-Macros With Best Regards. On 9/15/10, ashish koul wrote: > > check the attachment see if it helps > > On Mon, Sep 13, 2010 at 11:57 AM, Nalini wrote: > >&g

Re: $$Excel-Macros$$ Formula for Last Leave Date

2010-09-15 Thread Nalini P
, ashish koul wrote: > > hi check it see if it helps you also please post the question on group as > well because may be someone will give you better solution than mine > > > On Tue, Sep 14, 2010 at 3:58 PM, Nalini P wrote: > >> >> Dear Sir, >> >>

$$Excel-Macros$$ Formula for Last Leave Date

2010-09-13 Thread Nalini
Dear Sirs, I want to capture data which employees are on leave as on date and since when ? Formula please….. (Format enclosed) NAME01-Sep 02-Sep 03-Sep 04-Sep 05-Sep 06-Sep 07-Sep Leave Since A AB AB AB AB AB AB AB 01-Sep B pr pr