$$Excel-Macros$$ need help on maximum value and thier name

2012-06-24 Thread सुनिता पौडेल
Dear all, It has always been previlege to query on this group whenever needed and thanks from heart. I need one help regarding finding out maximum number and their name in one cell ? Have a wonderful day !! Thank you!! Sunita P.S: in case if file not attached(having probs) name amount*

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

2012-06-24 Thread Amit Gandhi
Thanks alot Mr. Rajan This function is Perfectly as per my requirement. Thanks once again Amit Gandhi On Sat, Jun 23, 2012 at 6:45 PM, Rajan_Verma wrote: > HI Amit, > > ** ** > > This function can work independently, you just need to understand the > function Arguments : > > *Function

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

2012-06-24 Thread jmothilal
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 wrote: > Dear Mothilal, > > If you don't want in Text Format Please use > > =DATEDIF(D2,E2,"d") select formula cell, press ctrl+1 and type in > custom yy mm d

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

2012-06-24 Thread ANKUR AGGARWAL
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 embed

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

2012-06-24 Thread Richard
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 workbook_ope

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

2012-06-24 Thread Mangesh Vimay
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 wrote: > Dear Ashutosh, > > Please find attach

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

2012-06-24 Thread Haseeb A
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 Hel

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

2012-06-24 Thread Sam Mathai Chacko
Not necessarily! Regards, Sam On Sun, Jun 24, 2012 at 8:40 AM, David Grugeon 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 >> few quo

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

2012-06-24 Thread Rajan_Verma
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: excel-

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

2012-06-24 Thread Ashutosh Sharma
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 Pr