Re: $$Excel-Macros$$ Excel test file Basic & Advance

2012-02-11 Thread xlstime
** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Maries > *Sent:* 07 February 2012 16:09 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Excel test file Basic & Advance > > ** ** > > *F

RE: $$Excel-Macros$$ Excel test file Basic & Advance

2012-02-08 Thread Amit Desai (MERU)
Dear Maries, This one was nice...can you please also provide us the solution for it? Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Maries Sent: 07 February 2012 16:09 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros

Re: $$Excel-Macros$$ Excel test file Basic & Advance

2012-02-07 Thread Nikhil Shah
Hi Maries, Thanks..Excellent Tools.. Regards Nikhil Shah On Tue, Feb 7, 2012 at 4:08 PM, Maries wrote: > *Find the attached Excel File > * > On Tue, Feb 7, 2012 at 11:43 AM, NOORAIN ANSARI > wrote: > >> PFA >> >> >> On Tue, Feb 7, 2012 at 12:42 PM, Amit Desai (MERU) < >> amit.de...@meruc

Re: $$Excel-Macros$$ Excel test file Basic & Advance

2012-02-07 Thread NOORAIN ANSARI
Thanks Maries for useful attachment. On Tue, Feb 7, 2012 at 4:08 PM, Maries wrote: > *Find the attached Excel File > * > On Tue, Feb 7, 2012 at 11:43 AM, NOORAIN ANSARI > wrote: > >> PFA >> >> >> On Tue, Feb 7, 2012 at 12:42 PM, Amit Desai (MERU) < >> amit.de...@merucabs.com> wrote: >> >>>

$$Excel-Macros$$ Excel test file Basic & Advance

2012-02-06 Thread Amit Desai (MERU)
Dear Team, Please forward excel test file for basic & advance level, if anybody have it. Best Regards, Amit Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intend

Re: $$Excel-Macros$$ Excel test

2011-08-06 Thread XLS S
Dear All, Nothing new On Fri, Aug 5, 2011 at 11:51 AM, NOORAIN ANSARI wrote: > Dear XLS, > > Please see attached solved sheet without helping column > > {=SUMPRODUCT(--(MONTH($B$7:$B$81)=$B84))} > > On Fri, Aug 5, 2011 at 3:19 AM, XLS S wrote: >> >> Excel test... >> >> -- >

RE: $$Excel-Macros$$ Excel test

2011-08-05 Thread Rajan_Verma
visible property of sheet2 is 2- xlSheetVeryHidden From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hanumant shinde Sent: Saturday, August 06, 2011 2:35 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel test Hi Noorain, how

Re: $$Excel-Macros$$ Excel test

2011-08-05 Thread hanumant shinde
Hi Noorain, how did you hide the sheet2. i could unhide it but programatically not manually. its not even xlsheetveryhidden > >From: NOORAIN ANSARI >To: excel-macros@googlegroups.com >Sent: Fri, 5 August, 2011 11:51:51 AM >Subject: Re: $$Excel-Macros$$ Excel test > >

Re: $$Excel-Macros$$ Excel test

2011-08-05 Thread mohit gupta
which course u are talking about --- On Fri, 8/5/11, Venkat CV wrote: From: Venkat CV Subject: Re: $$Excel-Macros$$ Excel test To: excel-macros@googlegroups.com Date: Friday, August 5, 2011, 11:39 AM Hi xlstime,   Updated Excel test below...     Best Regards, Venkat  Chennai On Fri, Aug

Re: $$Excel-Macros$$ Excel test

2011-08-04 Thread anandydr
Hi, One easy way can be to add a helper column and use =MONTH ( B7) to find the Month number for the date of birth in column B and then in the lower part of column B we can use =COUNUTIF($B$7:$B$81, B84) to see how many people were born in the first month which gives the result as 4 in this case.

$$Excel-Macros$$ Excel test

2011-08-04 Thread XLS S
Excel test... -- -- 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/grou

Re: $$Excel-Macros$$ Excel Test

2011-07-28 Thread Kumar Punnam
On Thu, Jul 28, 2011 at 12:05 PM, NOORAIN ANSARI wrote: > Dear All, > > Please find attached Excel Test. > -- > Thanks & regards, > Noorain Ansari > *http://noorain-ansari.blogspot.com/* > > -- > > ---

$$Excel-Macros$$ Excel Test

2011-07-27 Thread NOORAIN ANSARI
Dear All, Please find attached Excel Test. -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* -- -- Some important links for excel users: 1. Follow us on

$$Excel-Macros$$ Excel test required

2011-07-09 Thread Navneet Singh
Hi, Can somebody send me the toughtest excel( Excel 2003 or 2010) test asap. No. of questions doesn't matter. Will be a great help. Thanks! Navneet -- -- Some important links for excel users: 1. Follow us on TWITT