$$Excel-Macros$$ Lookup Query

2009-09-08 Thread gyanesh jain
Hi friends, I have some Query related with Lookup. its in attachment. can any provide the solution? -- Thanks, Gyanesh Jain, BE, MBA (Finance) +91 98868 68488 Please Save a tree...please don't print this e-mail unless you really ne

$$Excel-Macros$$ need array formula

2009-09-02 Thread gyanesh jain
Hi, How to use {=TABLE(,K11)} this type of function. -- Thanks, Gyanesh Jain, BE, MBA (Finance) +91 98868 68488 Please Save a tree...please don't print this e-mail unless you really ne

$$Excel-Macros$$ Re: Excel chart query

2009-07-21 Thread gyanesh jain
("&G2&")" > > Select the chart title and, in the formula bar, enter : > > =G4 > > Hope this helps. > > Daniel > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *gyanesh jain > *Sent:* m

$$Excel-Macros$$ Excel chart query

2009-07-21 Thread gyanesh jain
Hi All, check the attachment. If you change the country, in the chart "chart Title" should be change automatically. example rite now Chart Title is *Revenue (Rs. m)*. If I change the Select Country to USA, chart title should change to *Revenue ( USD m)*. -- Thanks, Gyanesh Jain

$$Excel-Macros$$ Interest Rate calculation

2009-04-26 Thread gyanesh jain
Hi, I have attached the solution. -- Thanks, Gyanesh Jain +91 98868 68488 Please Save a tree...please don't print this e-mail unless you really ne

$$Excel-Macros$$ Re: Concatenate Formula

2008-10-24 Thread gyanesh jain
I get the same result instead of MS > Excel 24-Oct-08. > > Please advice me if there is any other way out to get the result as > desired. > > Thanks in Advance > > Cheers > Shyam > > > > -- Thanks, Gyanesh Jain +91 98868 68488 Please Save a tree...please don&#

$$Excel-Macros$$ Re: Calculate total premium amount for a selected person.

2008-10-23 Thread gyanesh jain
gt; 4/15/2008 > 85,648.00 > Venki > Apr > 4/27/2008 > 95,624.00 > Shiva > Apr > 4/20/2008 > 8,000.00 > Rakesh > Apr > 4/9/2008 > 1,523.00 > Ramesh > May > 5/5/2008 > 20,000.00 > Satish > May > 5/6/2008 > 754,666.00 > Ra