rajanverma1...@gmail.com
To: excel-macros@googlegroups.com
Sent: Fri, 22 July, 2011 15:32:33
Subject: $$Excel-Macros$$ Excel Puzzle
Hope you will like it, J
--
--
Some important links for excel users:
1. Follow us
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
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
*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
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
: $$Excel-Macros$$ Excel Puzzle of the week
To: excel-macros@googlegroups.com
i agreed with Manoj
see the attachment
thanks regards
On Thu, Jan 6, 2011 at 12:20 PM, Manoj kumar manoj.vishwakarma...@gmail.com
wrote:
how about this...
=MONTH(1A1)
Regards,
Manoj Kumar
On Thu, Jan 6, 2011
: $$Excel-Macros$$ Excel Puzzle of the week
To: excel-macros@googlegroups.com
i agreed with Manoj
see the attachment
thanks regards
On Thu, Jan 6, 2011 at 12:20 PM, Manoj kumar manoj.vishwakarma...@gmail.com
wrote:
how about this...
=MONTH(1A1)
Regards,
Manoj Kumar
On Thu, Jan 6, 2011
Thanks Ashish , Manoj Maries...Your solutions are great !!
Maries, We can ignore Value formula from your solution and it still work ...
like =TEXT(A111,m)
Till now, Manoj's formula is smallest and easiest ...
Any one else wanna solve or comment on puzzle?
Regards,
Ayush Jain,
Microsoft
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
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
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
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
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
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
14 matches
Mail list logo