Re: $$Excel-Macros$$ Power pivot

Thanks . Let me check . On Mar 27, 2013 9:27 AM, "ashish koul" wrote: > Hi > > try this > > > http://technet.microsoft.com/en-us/library/gg413497.aspx > http://technet.microsoft.com/en-us/library/gg399078.aspx > http://www.microsoft.com/en-us/bi/powerpivot.aspx > > http://blogs.office.com/b/micro

Re: $$Excel-Macros$$ Excel-VBA QUIZ

Hi Noorain, Thanks for arranging Quiz-2. It helps us to analyze where we are.. And now eagerly waiting for result as today is the 5th day of this contest n also waiting to know for how many members takes part in this Quiz contest n whats our score.. And Ashish Sir & other friends here please tak

Re: $$Excel-Macros$$ Wish you all a very happy holi

Happy holi all excel expert. Sent from my BlackBerry® Smartphone on Loop Mobile. -Original Message- From: ashish Sender: excel-macros@googlegroups.com Date: Tue, 26 Mar 2013 21:00:38 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Wish you all a very happy holi

$$Excel-Macros$$ Wish you all a very happy holi

*Regards* *Ashish Koul* *Excel VBA Tips * -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? I

Re: $$Excel-Macros$$ Power pivot

Hi try this http://technet.microsoft.com/en-us/library/gg413497.aspx http://technet.microsoft.com/en-us/library/gg399078.aspx http://www.microsoft.com/en-us/bi/powerpivot.aspx http://blogs.office.com/b/microsoft-excel/archive/2009/10/23/using-powerpivot-with-excel-2010.aspx http://blogs.office.c

$$Excel-Macros$$ How to group a set of 10K running times in groups of 4 based on total time

Dear Experts, for a running event I need to create sets of 4 athletes from a list of athlete names with their 10K times (to be found in tab 10Km) Each created set of 4 athletes need a total time as close to 4 * the average time as possible. (to be placed in tab Sets) The 1,2 or 3 remaining ath

$$Excel-Macros$$ Power pivot

Hi, please help me some material on useage of power pivot in ms office 2010. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurat

Re: $$Excel-Macros$$ Serial Number

In cell j2 enter =IF(K2<>"",1,IF(AND(M2<>M3,M2<>""),J1+1,J1)) and fill down till end On Tue, Mar 26, 2013 at 7:02 PM, Sundarvelan N wrote: > Dear Friends, > > Please help me in this regard. > > I need to put serial number based on the uniqueid > > But the number should regenerate for every mon

Re: $$Excel-Macros$$ Source Link updation error

Pravin: Just Copy > Paste Special > Values the soure code will be removed and no Edit link errror will appear. On Tue, Mar 26, 2013 at 4:16 PM, Pravin Gunjal wrote: > Pl inform me how to remove those files. > > -- Forwarded message -- > From: xlstime > Date: Tue, Mar 26, 201

RE: $$Excel-Macros$$ Pivot table

It's not working it shows a syntax error in line From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of xlstime Sent: 26 March 2013 12:44 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Pivot table .. please check below link http://vbadud.bl

Fwd: $$Excel-Macros$$ Source Link updation error

Pl inform me how to remove those files. -- Forwarded message -- From: xlstime Date: Tue, Mar 26, 2013 at 5:38 PM Subject: Re: $$Excel-Macros$$ Source Link updation error To: excel-macros@googlegroups.com if another 2 files are not in use then remove it..

Re: $$Excel-Macros$$ Pivot table

.. please check below link http://vbadud.blogspot.in/2008/05/create-pivot-table-using-excel-vba.html . Enjoy Team XLS On Tue, Mar 26, 2013 at 5:51 PM, Manjunath Narayanappa < manjunath.narayana...@aon.co.uk> wrote: > But every day i need to run report & update in fre

RE: $$Excel-Macros$$ Pivot table

But every day i need to run report & update in fresh spreadsheet From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of xlstime Sent: 26 March 2013 12:07 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Pivot table Hi Maniunath, if headers are fix

Re: $$Excel-Macros$$ Source Link updation error

if another 2 files are not in use then remove it.. . Enjoy Team XLS On Tue, Mar 26, 2013 at 3:15 PM, Pravin Gunjal wrote: > Hi Xlstime, > > There are four sources are displaying there in this file. Out of which > two are available in my computer and two are not saved.

Re: $$Excel-Macros$$ Pivot table

Hi Maniunath, if headers are fixed then i think no need for create pivot-table on daily.. just refresh pivot daily ... . Enjoy Team XLS On Tue, Mar 26, 2013 at 3:42 PM, Manjunath Narayanappa < manjunath.narayana...@aon.co.uk> wrote: > Dear Experts > > > > Everyday I

Re: $$Excel-Macros$$ Re: Small Help Friends....

Hi Deepak, you can also use MIN with if condition with CSE like {=MIN(IF($C$3:$C$9=G3,$D$3:$D$9))} . Enjoy Team XLS On Tue, Mar 26, 2013 at 4:47 PM, अनिल नारायण गवली wrote: > Dude i want the Shiptocode of that minimum value. > > > > On Tue, Mar 26, 2013 at 4:44 PM, De

$$Excel-Macros$$ Re: Small Help Friends....

Hi Anil, Just paste the following formula in Cell J8 and Drag it out. =INDEX(C6:$F$20,MATCH(SMALL(F6:$F$20,(ROW($F$6:$F$20)-MIN(ROW($F$6:$F$20))+1)),$F$6:$F$20,0),3) with CSE Regards Prince On Tuesday, March 26, 2013 4:27:59 PM UTC+5:30, अनिल नारायण गवली wrote: > > Dear Friends, > > >

$$Excel-Macros$$ Re: Small Help Friends....

Dude i want the Shiptocode of that minimum value. On Tue, Mar 26, 2013 at 4:44 PM, Deepak Singh wrote: > Hi friend, > > Use below formula with CTR + SHift + Enter... > > =MIN(IF($E$6:$E$20=I8,$F$6:$F$20)) > > Thanks and Regards > Deepak Singh > > > On Tuesday, March 26, 2013 4:27:59 PM UTC+5:3

RE: $$Excel-Macros$$ Pivot table

Dear Experts Everyday I need to create pivot table to find the Age of each case( Query , WIP, untouched, draft) Is there any way to assign macro to the report Thanks Manjunath From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of xlstime Sent: 25 March 2013 17

Fwd: $$Excel-Macros$$ Source Link updation error

Hi Xlstime, There are four sources are displaying there in this file. Out of which two are available in my computer and two are not saved. But this is to inform you that I have taken these data by copy-paste from those two files which are not available right now. And I have not taken any data

Re: $$Excel-Macros$$ Source Link updation error

Hi Pravin, Please follow the below instructions press Alt + E +K for check source file then check source file available or not in location . Enjoy Team XLS On Tue, Mar 26, 2013 at 10:34 AM, Pravin Gunjal wrote: > Hi, > > I am getting the following error message, w

Fwd: $$Excel-Macros$$ Re: Source Link updation error

Also the same message is getting displayed while the opening the file every time. Even if we clicked as per the guidelines. -- Forwarded message -- From: Pravin Gunjal Date: Tue, Mar 26, 2013 at 1:47 PM Subject: Fwd: $$Excel-Macros$$ Re: Source Link updation error To: excel-macro

Fwd: $$Excel-Macros$$ Re: Source Link updation error

Dear Prince, But I would like to know where is the link updated in this file (in which cell). Please let me know. Thanks. Regards Pravin. -- Forwarded message -- From: Prince Date: Tue, Mar 26, 2013 at 11:13 AM Subject: $$Excel-Macros$$ Re: Source Link updation error To: excel-