Re: $$Excel-Macros$$ How to Find Last Present Date From Month in One column

acros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Daniel > Sent: Monday, August 01, 2011 1:24 PM > To: excel-macros@googlegroups.com > Subject: RE: $$Excel-Macros$$ How to Find Last Present Date From Month in > One column > > > > HI, > >

RE: $$Excel-Macros$$ How to Find Last Present Date From Month in One column

cel-macros@googlegroups.com Objet : Re: $$Excel-Macros$$ How to Find Last Present Date From Month in One column Dear Sir The formula given by Mr.Daniel is awesome but will give wrong results except for the first set. A slight modification as given below will bring out the intended result. =INDEX($A

RE: $$Excel-Macros$$ How to Find Last Present Date From Month in One column

t;,COLUMN($B$2:$AE$2 Copy down. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de maulik desai Envoyé : dimanche 31 juillet 2011 10:26 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ How to Find Last Present Date From Month

Re: $$Excel-Macros$$ How to Find Last Present Date From Month in One column

uillet 2011 10:26 > *À :* excel-macros@googlegroups.com > *Objet :* $$Excel-Macros$$ How to Find Last Present Date From Month in One > column > > ** ** > > Hi Group, > > > > Required Small help, > > I am having one excel sheet in that i have to

Re: $$Excel-Macros$$ How to Find Last Present Date From Month in One column

Hello Maulik, If you just have single characters in cells like "A","P" etc... use this, AF2 copy down. =LOOKUP(10,SEARCH("p",B2:AE2),B$1:AE$1) Or, =LOOKUP(2,1/(B2:AE2="p"),B$1:AE$1) The first one is more faster than second one. HTH Haseeb For tips visit; http://www.excelfox.com/forum/forum.

Re: $$Excel-Macros$$ How to Find Last Present Date From Month in One column

Dear Maulik, Please try it with ctrl+shift+Enter =OFFSET($A$1,0,LARGE(IF(B2:AE2="P",COLUMN($B$1:$AE$1),""),COLUMN(1:1))-1) -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Sun, Jul 31, 2011 at 1:56 PM, maulik desai wrote: > Hi

RE: $$Excel-Macros$$ How to Find Last Present Date From Month in One column

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de GoldenLance Envoyé : dimanche 31 juillet 2011 14:31 À : MS EXCEL AND VBA MACROS Objet : Re: $$Excel-Macros$$ How to Find Last Present Date >From Month in One column =INDEX($A$1:$AE$1,SUMPRODUCT(MAX(($B2:$AE2="P&q

RE: $$Excel-Macros$$ How to Find Last Present Date From Month in One column

e GoldenLance Envoyé : dimanche 31 juillet 2011 14:31 À : MS EXCEL AND VBA MACROS Objet : Re: $$Excel-Macros$$ How to Find Last Present Date From Month in One column =INDEX($A$1:$AE$1,SUMPRODUCT(MAX(($B2:$AE2="P")*COLUMN($B$1:$AE$1 will work without an array formula Dan :) On Jul 31,

Re: $$Excel-Macros$$ How to Find Last Present Date From Month in One column

** > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* maulik desai > *Envoyé :* dimanche 31 juillet 2011 10:26 > *À :* excel-macros@googlegroups.com > *Objet :* $$Excel-Macros$$ How to Find Last Present Date From Month in One > col

Re: $$Excel-Macros$$ How to Find Last Present Date From Month in One column

t;P",COLUMN($B$2:$AE$2 > > Copy down. > > Regards. > > Daniel > > De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De > la part de maulik desai > Envoyé : dimanche 31 juillet 2011 10:26 > À : excel-macros@googlegroups.com >

RE: $$Excel-Macros$$ How to Find Last Present Date From Month in One column

imanche 31 juillet 2011 10:26 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ How to Find Last Present Date From Month in One column Hi Group, Required Small help, I am having one excel sheet in that i have to update the Emp Attendance status for every month & actul no of Emp