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
Book10.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
