Re: $$Excel-Macros$$ Pls Help me in the attached file

2011-03-04 Thread Dharmesh Shah
Thank you very much to group and specially to people who helped me In this formula you have used Right Left function but in Right function u have used 2 times minus sign can u explain this please. Thanks Regards Dharmesh Shah On Fri, Mar 4, 2011 at 4:18 AM, siti Vi villager.g...@gmail.com

Re: $$Excel-Macros$$ income tax calculator

2011-03-04 Thread Sanjoy Nath
Thank you Nemi On Thu, Mar 3, 2011 at 12:01 PM, Nemi Gandhi nemigan...@gmail.com wrote: Sudhir vermaji, Attaached herewith income tax calculator in excel format. See if its useful? -- Nemi Gandhi 98204 92963 --

Re: $$Excel-Macros$$ income tax calculator

2011-03-04 Thread sudhir kumar
thanx and if you will find it's update version please sent me. On 3 March 2011 08:31, Nemi Gandhi nemigan...@gmail.com wrote: Sudhir vermaji, Attaached herewith income tax calculator in excel format. See if its useful? -- Nemi Gandhi 98204 92963 --

Re: Fwd: $$Excel-Macros$$ new querry

2011-03-04 Thread Nemi Gandhi
Thanks all for solution. Nemi Gandhi On Mar 3, 3:10 pm, §»VIPER«§ viper@gmail.com wrote: Hi Ignore my previous mail. Now check the attachment and revert if it is not helpful. -- *Thanks Regards Thamu * On Wed, Mar 2, 2011 at 10:45 AM, Nemi Gandhi nemigan...@gmail.com wrote:

Re: $$Excel-Macros$$ Open an Excel File into its own seperate window in Excel.

2011-03-04 Thread Sanjoy Nath
This is really great. And we need to know the options for %2 %3 also in the open parameters On Sun, Feb 27, 2011 at 10:18 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Susan, Seems to be interesting issue:- Two workarounds:- 1) Try closing the other Excel by key combination Ctrl + W.

Re: $$Excel-Macros$$ Problem on picking series in chart

2011-03-04 Thread Sanjoy Nath
I you hide the data columns , Excel Will not show those columns in the chart Excel Only shows the chart of visible columns and the filtered data On Sun, Feb 27, 2011 at 10:33 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Gaurav, I hv tried opening the attached file but it appears to be

Re: $$Excel-Macros$$ Entry of more than 16 characters in a cell

2011-03-04 Thread Sanjoy Nath
Will that behave as number? that will behave as text then On Sat, Feb 26, 2011 at 8:57 PM, Anil Bhange anil.bha...@tatacommunications.com wrote: XL has a specification limit of 15 decimal digits of precision (see Help, Specifications). There's nothing you can to in XL itself to extend

Re: $$Excel-Macros$$ Help in Data validation

2011-03-04 Thread §»VIPER«§
Hi find the attachment and revert if it is not what you want. -- *Thanks Regards Thamu * On Wed, Mar 2, 2011 at 11:54 AM, naresh v naresh.veerabo...@gmail.comwrote: Hi Rambabu, please find the solution.. Regards, Naresh V, Analyst Hyderabad. On Wed, Mar 2, 2011

Re: $$Excel-Macros$$ Re: Report reconcile

2011-03-04 Thread kurikkal padinjarappalla
And also the can we show the amt in difference column itself instead of 'NA' if it is as not found in report also. Regards, Kurikkal. On Fri, Mar 4, 2011 at 6:59 PM, kurikkal padinjarappalla padinjarappa...@gmail.com wrote: Dear Saurabh, Thank u very much!! It works great,

Re: $$Excel-Macros$$ Fwd: Help on formula

2011-03-04 Thread Jorge Marques
Ahh perfect it condenses the 4 conditions to at least 2, it´s still a little confusing for me to put formula into formulas and organize them. 1001 thanks Paul, Excellent as usual :) 2011/3/3 Paul Schreiner schreiner_p...@att.net I would use:

Re: $$Excel-Macros$$ help with formating

2011-03-04 Thread pawel lupinski
Thanks Mate, its great From: STDEV(i) setiyowati.d...@gmail.com To: excel-macros@googlegroups.com Cc: pawel lupinski lupins...@yahoo.com Sent: Fri, March 4, 2011 6:31:35 PM Subject: Re: $$Excel-Macros$$ help with formating see inside if it help On Fri, Mar

Re: $$Excel-Macros$$ help with formating

2011-03-04 Thread ChilExcel
with conditional formatting you just have to change% for conditions 1,2,3 chilexcel 2011/3/4 pawel lupinski lupins...@yahoo.com Hi All, I realy need your help with formating of the cells. see inside. Thanks Pawel --

$$Excel-Macros$$ Re: Problem on picking series in chart

2011-03-04 Thread mahamadou lawali
See attached file if it helps -- -- 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 @

$$Excel-Macros$$ Help needed - Extract data by customer name

2011-03-04 Thread San Pat
Hi Friends, I have row data in the sheet1, which contains multiple data entries for the same customer. I am trying to extract each customer data in separate sheet (Extract_Data) and at the same time calculating the average price sum of the total quantity shipped to the particular customer.

Re: $$Excel-Macros$$ Pls Help me in the attached file

2011-03-04 Thread §»VIPER«§
Hi dharmesh simply it will convert text (which numbers in text formats) to values. equivalent to (value) function. -- *Thanks Regards Thamu * On Fri, Mar 4, 2011 at 10:52 AM, Dharmesh Shah dharmeshsha...@gmail.comwrote: Thank you very much to group and specially to people who helped me In

Re: $$Excel-Macros$$ Re: Ashish Koul : Most helpful Member

2011-03-04 Thread ashish koul
thank you all On Thu, Mar 3, 2011 at 9:49 AM, Jenie janetdicks...@gmail.com wrote: Congratulation Ashish... keep it up -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of DILIPandey Sent: Wednesday, March 02, 2011 3:07 PM To: