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

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$1:$AE$1,1,MAX(IF($B2:$AE2="P",COLUM

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$1:$AE$1,1,MAX(IF($B2:$AE2="P",COLUMN($B2:$AE2 In the above formula, the second and the third ranges shoul

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

HI, just copy paste the below formula till your last employee which will give you accurate results =INDEX($A$1:$AE$1,1,MAX(IF($B2:$AE2="P",COLUMN($B$2:$AE$2 as mentioned bellow with Ctr+shift+Enter On Sun, Jul 31, 2011 at 5:50 PM, Daniel wrote: > Hi, > > ** ** > > In AF2 (array formul

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, 5:20 pm, "Daniel" wrote: > Hi, > > In AF2 (array formula, validate with Ctrl+Shift+Enter) : > > =INDEX($A$1:$AE$1,1,MAX(IF($B$2:$AE$2="P",COLUMN($B$2:$AE$2 > > Copy down.

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

Hi, In AF2 (array formula, validate with Ctrl+Shift+Enter) : =INDEX($A$1:$AE$1,1,MAX(IF($B$2:$AE$2="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 j