hi gurus,
thanks you so much to all of u for the effort for the solution. it
really helps alot
thanks again
On 8/1/11, Rajan_Verma <rajanverma1...@gmail.com> wrote:
>
>
> See the attached File,
>
> Hope it will help you .
>
> {=MAX((A2:L2="P")*A1:L1)}
>
>
>
> From: excel-macros@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,
>
>
>
> True enough ! Sorry, I just tested the first cell ;-(
>
>
>
> Regards.
>
> Daniel
>
>
>
> De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
> la part de Viswanathan M
> Envoyé : dimanche 31 juillet 2011 19:05
> À : excel-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$1:$AE$1,1,MAX(IF($B2:$AE2="P",COLUMN($B2:$AE2))))
>
>
>
> In the above formula, the second and the third ranges should be of mixed
> referencing.
>
> regards
>
> viswanathan m
>
> On Sun, Jul 31, 2011 at 5:50 PM, Daniel <dcolarde...@free.fr> 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.
>
>
>
> 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 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 are more then 500 & I have to
> update their last Present date in Final column. (details given in Attached
> File)
>
>
>
> Currently i have to find out date manually & its take long time to update.
>
> Request you to kindly provide the solution.
>
> --
> Thanks & Regards,
> Maulik Desai
> 9967363926
>
> --
> ----------------------------------------------------------------------------
> ------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> <http://www.excel-macros.blogspot.com/>
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> <http://www.quickvba.blogspot.com/>
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> <http://exceldailytip.blogspot.com/>
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
> ----------------------------------------------------------------------------
> ------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> <http://www.excel-macros.blogspot.com/>
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> <http://www.quickvba.blogspot.com/>
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> <http://exceldailytip.blogspot.com/>
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
>
> --
>
> With warm regards
>
> Viswanathan M
> DE(Tech)
> RGM TTC Chennai-600027
> mviswanat...@bsnl.co.in
> 94861 00423
> Vande Mataram
>
>
>
> --
> ----------------------------------------------------------------------------
> ------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
> ----------------------------------------------------------------------------
> ------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
Thanks & Regards,
Maulik Desai
9967363926
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
