$$Excel-Macros$$ What is pivot table, i could not do this.... Can any body help?

I started using Hlookup, Vlookup but what is pivot table and uses, if any body can tell.. Regards, Ashutosh -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code

RE: $$Excel-Macros$$ What is pivot table, i could not do this.... Can any body help?

Pivot table is feature of excel that enable you to summarize the data very instantly , you can go through this link to get more information about pivot table: http://chandoo.org/wp/2009/08/19/excel-pivot-tables-tutorial/ Regards Rajan verma +91 7838100659 [IM-Gtalk] From:

Re: $$Excel-Macros$$ Re: Join Sql statement in VB using ADODB

Not necessarily! Regards, Sam On Sun, Jun 24, 2012 at 8:40 AM, David Grugeon da...@grugeon.com.au wrote: I thought SQL required all statements to end in a semicolon ?? On Sunday, 24 June 2012, TJ wrote: Thanks much I went ahead a copied that into the Editor and it looks like it added a

$$Excel-Macros$$ Re: VLOOKUP OR SUMPRODUCT FORMULA HELP

Hello Amit, Try this in G15 and copy down across. =SUMPRODUCT(ISNUMBER(MATCH($F15|$F$5:$F$9,$A$5:$A$21|$B$5:$B$21,0))+0,G$5:G$9) Regards, Haseeb -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

Re: $$Excel-Macros$$ What is pivot table, i could not do this.... Can any body help?

Hi All, I even can't imagine my entire life without this Group.. Agar mai successful raha to The contribution of this excel group would be 99.99% to my success. 0.01% I would like to keep for myself. Thanks 2 All !!! On 6/24/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear

$$Excel-Macros$$ Macro to copy a macro from one workbook to another

I would like to create a macro to copy a macro from one workbooks module area to another workbooks ThisWorkbook area. The first workbook is the master and any other workbook would be subsets of the master. The idea is to have a macro that will further lock cells from input (sub

$$Excel-Macros$$ Interesteing Problem : - Morefunc Addin - Why it could not be embedded like in Excel 2003?

Hi all, Good Morning. There is an exciting challenge ahead of me.  Has any one worked on Morefunc Addin ? Mconcat fn  is used as an add - in in excel 2003.  There is a Big 200 MB Model, where in one of the worksheets, Mconcat fn ( utility of the add-in) is used. This add-in can easily be

Re: $$Excel-Macros$$ age month days calculations - Reg

Thanks noorain babu..!! sir this command is very useful for me, Thanks so much for u. On Sat, Jun 23, 2012 at 12:08 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Mothilal, If you don't want in Text Format Please use =DATEDIF(D2,E2,d) select formula cell, press ctrl+1 and type