$$Excel-Macros$$ Re: Urgent help needed please

Hello Arpita, A little confusion in the part "=><1/-1" If you want to SUM all >0 values, you can use * =SUMIF(A1:A16,">0",A1:A16)* If you are looking to SUM between >=-1 to 1 (minus 1 to positive 1), use * =SUM(SUMIF(A1:A16,{">=**-**1",">1"},A1:A16)*{1,-1})* HTH Haseeb On Monday, February 27,

$$Excel-Macros$$ Re: Urgent Help needed regarding using macro

Use This formula just change the range =SUMPRODUCT(MAX(($A$2:$A$100=A3)*($D$2:$D$100))) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/excelda

Re: $$Excel-Macros$$ Re: Urgent Help Needed!!

Regards - Dave. > > -- > Date: Thu, 7 Jan 2010 12:36:39 +0530 > > Subject: Re: $$Excel-Macros$$ Re: Urgent Help Needed!! > From: pkkara...@gmail.com > > To: excel-macros@googlegroups.com > > Hello Anish, > > Please check the attached file and let me know if this is what y

Re: $$Excel-Macros$$ Re: Urgent Help Needed!!

Jan 2010 12:36:39 +0530 > > Subject: Re: $$Excel-Macros$$ Re: Urgent Help Needed!! > From: pkkara...@gmail.com > > To: excel-macros@googlegroups.com > > Hello Anish, > > Please check the attached file and let me know if this is what you were > looking for. > > run the

RE: $$Excel-Macros$$ Re: Urgent Help Needed!!

Hey Praveen, Good solution. I didn't think of doing it by macro. Pretty silly when this is a macro group! Regards - Dave. Date: Thu, 7 Jan 2010 12:36:39 +0530 Subject: Re: $$Excel-Macros$$ Re: Urgent Help Needed!! From: pkkara...@gmail.com To: excel-macros@googlegroups.com Hello Anish, P

Re: Thanks praveen, Dave, Ankur!! Re: $$Excel-Macros$$ Re: Urgent Help Needed!!

multibyte character strings >> >> Regards, >> Praveen >> >> On Wed, Jan 6, 2010 at 3:57 PM, Anish Shrivastava >> wrote: >> >>> Experts >>> >>> Please help....or advice if it is possible... >>> >>>

Thanks praveen, Dave, Ankur!! Re: $$Excel-Macros$$ Re: Urgent Help Needed!!

gt; -- Forwarded message -- >> From: Anish Shrivastava >> Date: Tue, Jan 5, 2010 at 2:29 PM >> Subject: Re: $$Excel-Macros$$ Re: Urgent Help Needed!! >> To: excel-macros@googlegroups.com >> >> >> Hi Dave, >> >> Attached please find

Re: $$Excel-Macros$$ Re: Urgent Help Needed!!

> Date: Tue, Jan 5, 2010 at 2:29 PM > Subject: Re: $$Excel-Macros$$ Re: Urgent Help Needed!! > To: excel-macros@googlegroups.com > > > Hi Dave, > > Attached please find the file with sample data, I have seprated titles > Character wise...we have 3 categories.. > ENGLI

Fwd: $$Excel-Macros$$ Re: Urgent Help Needed!!

Experts Please helpor advice if it is possible... -- Forwarded message -- From: Anish Shrivastava Date: Tue, Jan 5, 2010 at 2:29 PM Subject: Re: $$Excel-Macros$$ Re: Urgent Help Needed!! To: excel-macros@googlegroups.com Hi Dave, Attached please find the file with

Re: $$Excel-Macros$$ Re: Urgent Help Needed!!

at 6:43 PM, Dave Bonallack wrote: > Please attach a workbook with a sample of English and non-English > characters > Regards - Dave > > -- > Date: Mon, 4 Jan 2010 15:40:08 +0530 > Subject: $$Excel-Macros$$ Re: Urgent Help Needed!! > From: anish..

RE: $$Excel-Macros$$ Re: Urgent Help Needed!!

Please attach a workbook with a sample of English and non-English characters Regards - Dave Date: Mon, 4 Jan 2010 15:40:08 +0530 Subject: $$Excel-Macros$$ Re: Urgent Help Needed!! From: anish@gmail.com To: excel-macros@googlegroups.com Experts!!! Any updates on below query?? Thanks

$$Excel-Macros$$ Re: Urgent Help Needed!!

Experts!!! Any updates on below query?? Thanks!! ANISh On Wed, Dec 30, 2009 at 1:31 PM, Anish Shrivastava wrote: > Hello Experts, > > Thank you very much for helping me on my earlier queries. > Could you please help me in finding cells which contains multibyte > characters. > I mean how can we

$$Excel-Macros$$ Re: Urgent Help needed : Excel Headers

Thankss it worked :-) On 4/9/09, Manoj S Negi wrote: > > Hi Mahreen, > > Follow the below mentioned procedure for the same. > 1. go to the file menu > 2. select page setup > 3. click on sheet tab > 4. there is option "Rows to repeat at top" click on that and give the range > of required field > 5

$$Excel-Macros$$ Re: Urgent Help needed : Excel Headers

Dear The following codewill put a Left headerin each worksheetin the w

$$Excel-Macros$$ Re: Urgent Help needed : Excel Headers

Hi Mahreen, Follow the below mentioned procedure for the same. 1. go to the file menu 2. select page setup 3. click on sheet tab 4. there is option "Rows to repeat at top" click on that and give the range of required field 5. than come back by click on ok and print it. *Unfeigned Regards Manoj

$$Excel-Macros$$ Re: urgent help needed

Hi Pavithrak, Not sre what markers are required. i had updated three radio buttons but not sure of the code which you require the below link has the option of adding the code. *http://www.functionx.com/excel2003/articles/radiobuttons.htm* regards Hari kumar On Wed, Feb 18, 2009 at 8:56 AM, pavithr