Re: $$Excel-Macros$$ Excel Puzzle

2011-07-24 Thread Michael Brumby
: 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 on TWITTER for tips

$$Excel-Macros$$ Excel Puzzle

2011-07-22 Thread Rajan_Verma
Hope you will like it, J -- -- 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/gr

Re: $$Excel-Macros$$ Excel Puzzle of the week - Winner is Manoj Kumar

2011-01-10 Thread Dilip Pandey
warded message -- >> From: ayush jain >> 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

Re: $$Excel-Macros$$ Excel Puzzle of the week - Winner is Manoj Kumar

2011-01-09 Thread Manoj kumar
Thanks :) Regards, Manoj Kumar On Sat, Jan 8, 2011 at 2:58 PM, Maries wrote: > Congrats Mr.Manoj.. > > -- Forwarded message -- > From: ayush jain > Date: Sat, Jan 8, 2011 at 2:49 PM > Subject: $$Excel-Macros$$ Excel Puzzle of the week - Winner is Manoj

Fwd: $$Excel-Macros$$ Excel Puzzle of the week - Winner is Manoj Kumar

2011-01-08 Thread Maries
Congrats Mr.Manoj.. -- Forwarded message -- From: ayush jain 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

$$Excel-Macros$$ Excel Puzzle of the week - Winner is Manoj Kumar

2011-01-08 Thread ayush jain
* ayush jain > > *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

Re: $$Excel-Macros$$ Excel Puzzle of the week

2011-01-06 Thread Paul Schreiner
given the string is in Cell A1, use: = MONTH("01-"&LEFT(A1,3)) Paul From: ayush jain 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...i

Re: Fwd: $$Excel-Macros$$ Excel Puzzle of the week

2011-01-06 Thread Ayush
Thanks Ashish , Manoj & Maries...Your solutions are great !! Maries, We can ignore Value formula from your solution and it still work ... like =TEXT(A11&1,"m") Till now, Manoj's formula is smallest and easiest ... Any one else wanna solve or comment on puzzle? Regards, Ayush Jain, Microsoft

Fwd: $$Excel-Macros$$ Excel Puzzle of the week

2011-01-06 Thread Maries
Dear Ayush Jain, Please find the attached file. this also one of way to find the months using the following formula. =TEXT(VALUE(A1&1),"m") Thank you, Regards, Maries -- Forwarded message -- From: Rohan Young Date: Thu, Jan 6, 2011 at 2:08 PM Subject: Re:

Fwd: $$Excel-Macros$$ Excel Puzzle of the week

2011-01-06 Thread Maries
Dear Ayush Jain, Please find the attached file. this also one of way to find the months using the following formula. =TEXT(VALUE(A1&1),"m") Thank you, Regards, Maries -- Forwarded message -- From: Rohan Young Date: Thu, Jan 6, 2011 at 2:08 PM Subject: Re:

Re: $$Excel-Macros$$ Excel Puzzle of the week

2011-01-06 Thread Rohan Young
i agreed with Manoj see the attachment thanks & regards On Thu, Jan 6, 2011 at 12:20 PM, Manoj kumar wrote: > how about this... > > =MONTH(1&A1) > > > Regards, > Manoj Kumar > > > On Thu, Jan 6, 2011 at 12:05 PM, ayush jain wrote: > >> Wow AshishSuperfast...I liked it.. >> >> Dear group,

Re: $$Excel-Macros$$ Excel Puzzle of the week

2011-01-05 Thread Manoj kumar
how about this... =MONTH(1&A1) Regards, Manoj Kumar On Thu, Jan 6, 2011 at 12:05 PM, ayush jain 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 wrote: > >> check the attachment >>

Re: $$Excel-Macros$$ Excel Puzzle of the week

2011-01-05 Thread ayush jain
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 wrote: > check the attachment > > MONTH(VALUE(LEFT(A1,3)&1)) > > On Thu, Jan 6, 2011 at 11:54 AM, Ayush wrote: > >> Dear members, >> >> There is a excel p

Re: $$Excel-Macros$$ Excel Puzzle of the week

2011-01-05 Thread ashish koul
check the attachment MONTH(VALUE(LEFT(A1,3)&1)) On Thu, Jan 6, 2011 at 11:54 AM, Ayush 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 for

Re: $$Excel-Macros$$ Excel Puzzle of the week

2011-01-05 Thread ayush jain
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 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 ,

$$Excel-Macros$$ Excel Puzzle of the week

2011-01-05 Thread Ayush
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