Re: $$Excel-Macros$$ Excel Puzzle of the week - Winner is Manoj Kumar
congratulations Manoj.. :) Best Regards, DILIPandey On Mon, Jan 10, 2011 at 9:18 AM, Manoj kumar manoj.vishwakarma...@gmail.com wrote: Thanks :) Regards, Manoj Kumar On Sat, Jan 8, 2011 at 2:58 PM, Maries talk2mar...@gmail.com wrote: Congrats Mr.Manoj.. -- Forwarded message -- From: ayush jain jainayus...@gmail.com Date: Sat, Jan 8, 2011 at 2:49 PM Subject: $$Excel-Macros$$ Excel Puzzle of the week - Winner is Manoj Kumar To: excel-macros@googlegroups.com Cc: manoj.vishwakarma...@gmail.com Dear Group, The winner of this puzzle has been selected as Manoj. His formula is shortest and working very well. The formula is =MONTH(1A1). I will publish the same on the blog with his name. Congratulations Manoj ! Thank you all for participating! The new puzzle is on the waySTAY TUNED . Thanks Best Regards, Ayush Jain Group Manager Microsoft MVP On Thu, Jan 6, 2011 at 7:33 PM, Paul Schreiner schreiner_p...@att.netwrote: given the string is in Cell A1, use: = MONTH(01-LEFT(A1,3)) Paul -- *From:* ayush jain jainayus...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thu, January 6, 2011 1:26:42 AM *Subject:* Re: $$Excel-Macros$$ Excel Puzzle of the week there was Typo in example...its Decem to 12 Submit your answer now. :D Thnx again. On Thu, Jan 6, 2011 at 11:54 AM, Ayush jainayus...@gmail.com wrote: Dear members, There is a excel puzzle for you. Let see who all can give the answer correctly. There is a data of [month] in excel with no fixed length , minimum three characters, text format. You need to develop formula (Not Macro) which can convert it into number. For example Jan to 1 March to 3 Apr to 4. Decem to 5. so on. The best formula(short relevant) winner name will be published on exceldailytip.blogspot.com blog of this group. Let see who is the first and who is the winner. Thank you. Best Regards, Ayush Jain Group Manager Microsoft MVP -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- Best regards, Ayush Jain -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- Best regards, Ayush Jain -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our
Re: $$Excel-Macros$$ Excel Puzzle of the week - Winner is Manoj Kumar
Thanks :) Regards, Manoj Kumar On Sat, Jan 8, 2011 at 2:58 PM, Maries talk2mar...@gmail.com wrote: Congrats Mr.Manoj.. -- Forwarded message -- From: ayush jain jainayus...@gmail.com Date: Sat, Jan 8, 2011 at 2:49 PM Subject: $$Excel-Macros$$ Excel Puzzle of the week - Winner is Manoj Kumar To: excel-macros@googlegroups.com Cc: manoj.vishwakarma...@gmail.com Dear Group, The winner of this puzzle has been selected as Manoj. His formula is shortest and working very well. The formula is =MONTH(1A1). I will publish the same on the blog with his name. Congratulations Manoj ! Thank you all for participating! The new puzzle is on the waySTAY TUNED . Thanks Best Regards, Ayush Jain Group Manager Microsoft MVP On Thu, Jan 6, 2011 at 7:33 PM, Paul Schreiner schreiner_p...@att.netwrote: given the string is in Cell A1, use: = MONTH(01-LEFT(A1,3)) Paul -- *From:* ayush jain jainayus...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thu, January 6, 2011 1:26:42 AM *Subject:* Re: $$Excel-Macros$$ Excel Puzzle of the week there was Typo in example...its Decem to 12 Submit your answer now. :D Thnx again. On Thu, Jan 6, 2011 at 11:54 AM, Ayush jainayus...@gmail.com wrote: Dear members, There is a excel puzzle for you. Let see who all can give the answer correctly. There is a data of [month] in excel with no fixed length , minimum three characters, text format. You need to develop formula (Not Macro) which can convert it into number. For example Jan to 1 March to 3 Apr to 4. Decem to 5. so on. The best formula(short relevant) winner name will be published on exceldailytip.blogspot.com blog of this group. Let see who is the first and who is the winner. Thank you. Best Regards, Ayush Jain Group Manager Microsoft MVP -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- Best regards, Ayush Jain -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- Best regards, Ayush Jain -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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
Re: $$Excel-Macros$$ Excel Puzzle of the week
given the string is in Cell A1, use: = MONTH(01-LEFT(A1,3)) Paul From: ayush jain jainayus...@gmail.com To: excel-macros@googlegroups.com Sent: Thu, January 6, 2011 1:26:42 AM Subject: Re: $$Excel-Macros$$ Excel Puzzle of the week there was Typo in example...its Decem to 12 Submit your answer now. :D Thnx again. On Thu, Jan 6, 2011 at 11:54 AM, Ayush jainayus...@gmail.com wrote: Dear members, There is a excel puzzle for you. Let see who all can give the answer correctly. There is a data of [month] in excel with no fixed length , minimum three characters, text format. You need to develop formula (Not Macro) which can convert it into number. For example Jan to 1 March to 3 Apr to 4. Decem to 5. so on. The best formula(short relevant) winner name will be published on exceldailytip.blogspot.com blog of this group. Let see who is the first and who is the winner. Thank you. Best Regards, Ayush Jain Group Manager Microsoft MVP -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- Best regards, Ayush Jain -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Excel Puzzle of the week
there was Typo in example...its Decem to 12 Submit your answer now. :D Thnx again. On Thu, Jan 6, 2011 at 11:54 AM, Ayush jainayus...@gmail.com wrote: Dear members, There is a excel puzzle for you. Let see who all can give the answer correctly. There is a data of [month] in excel with no fixed length , minimum three characters, text format. You need to develop formula (Not Macro) which can convert it into number. For example Jan to 1 March to 3 Apr to 4. Decem to 5. so on. The best formula(short relevant) winner name will be published on exceldailytip.blogspot.com blog of this group. Let see who is the first and who is the winner. Thank you. Best Regards, Ayush Jain Group Manager Microsoft MVP -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- Best regards, Ayush Jain -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Excel Puzzle of the week
check the attachment MONTH(VALUE(LEFT(A1,3)1)) On Thu, Jan 6, 2011 at 11:54 AM, Ayush jainayus...@gmail.com wrote: Dear members, There is a excel puzzle for you. Let see who all can give the answer correctly. There is a data of [month] in excel with no fixed length , minimum three characters, text format. You need to develop formula (Not Macro) which can convert it into number. For example Jan to 1 March to 3 Apr to 4. Decem to 5. so on. The best formula(short relevant) winner name will be published on exceldailytip.blogspot.com blog of this group. Let see who is the first and who is the winner. Thank you. Best Regards, Ayush Jain Group Manager Microsoft MVP -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts puzzle.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Excel Puzzle of the week
Wow AshishSuperfast...I liked it.. Dear group, Do you have better answer to beat ashish :P On Thu, Jan 6, 2011 at 11:57 AM, ashish koul koul.ash...@gmail.com wrote: check the attachment MONTH(VALUE(LEFT(A1,3)1)) On Thu, Jan 6, 2011 at 11:54 AM, Ayush jainayus...@gmail.com wrote: Dear members, There is a excel puzzle for you. Let see who all can give the answer correctly. There is a data of [month] in excel with no fixed length , minimum three characters, text format. You need to develop formula (Not Macro) which can convert it into number. For example Jan to 1 March to 3 Apr to 4. Decem to 5. so on. The best formula(short relevant) winner name will be published on exceldailytip.blogspot.com blog of this group. Let see who is the first and who is the winner. Thank you. Best Regards, Ayush Jain Group Manager Microsoft MVP -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- Best regards, Ayush Jain -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Excel Puzzle of the week
how about this... =MONTH(1A1) Regards, Manoj Kumar On Thu, Jan 6, 2011 at 12:05 PM, ayush jain jainayus...@gmail.com wrote: Wow AshishSuperfast...I liked it.. Dear group, Do you have better answer to beat ashish :P On Thu, Jan 6, 2011 at 11:57 AM, ashish koul koul.ash...@gmail.comwrote: check the attachment MONTH(VALUE(LEFT(A1,3)1)) On Thu, Jan 6, 2011 at 11:54 AM, Ayush jainayus...@gmail.com wrote: Dear members, There is a excel puzzle for you. Let see who all can give the answer correctly. There is a data of [month] in excel with no fixed length , minimum three characters, text format. You need to develop formula (Not Macro) which can convert it into number. For example Jan to 1 March to 3 Apr to 4. Decem to 5. so on. The best formula(short relevant) winner name will be published on exceldailytip.blogspot.com blog of this group. Let see who is the first and who is the winner. Thank you. Best Regards, Ayush Jain Group Manager Microsoft MVP -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- Best regards, Ayush Jain -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts