Re: $$Excel-Macros$$ - Sunil B.N

2012-03-27 Thread sunil bn
thnq so much.. On Tue, Mar 27, 2012 at 1:10 PM, Abhishek Jain wrote: > Right Click on cell...choose format cells > Custom > under the "Type:" use > this - > > *[>=1000]##\,##\,##\,##0;[>=10] ##\,##\,##0;##,##0 * > > > > On Tue, Mar 27, 2012 a

Re: $$Excel-Macros$$ - Sunil B.N

2012-03-27 Thread sunil bn
Hi Abhishek Jain , one more help. I need number should shown in Indian format like. Example 55,55,555 On Tue, Mar 27, 2012 at 12:43 PM, sunil bn wrote: > Hi Abhishek Jain , > > Sorry i got it... thnx very much..! > > Regards > Sunil B.N > > > On Tue, Mar 27, 2012

Re: $$Excel-Macros$$ - Sunil B.N

2012-03-27 Thread sunil bn
Hi Abhishek Jain , Sorry i got it... thnx very much..! Regards Sunil B.N On Tue, Mar 27, 2012 at 12:39 PM, Abhishek Jain wrote: > Did you change trying the syntax? > > > On Tue, Mar 27, 2012 at 12:32 PM, sunil bn wrote: > >> Hi Abhishek Jain , >> >> Its not

Re: $$Excel-Macros$$ - Sunil B.N

2012-03-27 Thread sunil bn
Hi Abhishek Jain , Its not working! On Tue, Mar 27, 2012 at 12:23 PM, Abhishek Jain wrote: > Didn't try, but should work - > > http://answers.yahoo.com/question/index?qid=20071016005523AAlKbBa > > > On Tue, Mar 27, 2012 at 11:36 AM, sunil bn wrote: > >>

Re: $$Excel-Macros$$ excel macros - Sunil B.N

2012-02-09 Thread sunil bn
(F1:F10,">0")/COUNTIF(F1:F10,">0") > > =SUM(F1:F10)/(SUMPRODUCT((F1:F10<>0)*1)) > > Regards, > > MARIES. > > On Thu, Feb 9, 2012 at 3:19 PM, sunil bn wrote: > >> need “average formula” which includes 0 value > > > -- > FORUM RULES

$$Excel-Macros$$ excel macros - Sunil B.N

2012-02-09 Thread sunil bn
Hi Expert, Please find the attached file. 1. I need “average formula” which includes 0 value. -- *Regards* **Sunil B.N *** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Fo

$$Excel-Macros$$ - Sunil B.N

2012-01-09 Thread sunil bn
Hi Expert, I have attached file kindly help me to solve this. -- *Regards* **Sunil B.N ***9035858585 -- 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 Problem, and

Re: $$Excel-Macros$$ Please help...!!

2012-01-02 Thread sunil bn
Hi Satvik, use the below formula . =(today()-A1)/30.5 On Mon, Jan 2, 2012 at 9:32 PM, Satvik wrote: > Dear Excel Members, > > Please help me how to calculate the Tenurity of a agent. > > Regards, > Satvik > Sent from BlackBerry® on Airtel > > -- > FORUM RULES (934+ members already BANNED for v

$$Excel-Macros$$

2011-12-16 Thread sunil bn
Hi Expert, I Have one doubt in power point 1. how to create our own templates in power point with out company logo Please revert with some snap's. -- *Regards* **Sunil B.N ***9035858585 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. P

Re: $$Excel-Macros$$ Excel-marco- need u r help -- $unil

2011-11-03 Thread sunil bn
Thnq very much On Thu, Nov 3, 2011 at 11:23 PM, Haseeb Avarakkan < haseeb.avarak...@gmail.com> wrote: > Hello Sunil; > > Also, you can use SUMIF, > > =SUMIF(A2:A11,"<="&TODAY(),B2:B11) > > _ > HTH > Haseeb > > -- > FORUM RULES (925+ members already BANNED for violation) > > 1) Use concis

$$Excel-Macros$$ Excel-marco- need u r help -- $unil

2011-11-03 Thread sunil bn
Hi Expert, I Need the formula here to calculate from 1st of Nov to current day on daily basis automatically. attached file your reference. -- *Regards* **Sunil B.N ***9035858585 -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread tit

Re: $$Excel-Macros$$ Shortcut key for Border

2011-10-12 Thread sunil bn
Hi, Its excel 2007..Its not working in excel2003... Regards Sunil On 13 Oct 2011 10:38, "karan 1237" wrote: > Hey Ankit, > > Please see below image : > For all border press Alt+H+B+A > For outline border Ctrl+Shift+& > & for all border commands > press Alt+H+B+ then press character which is sho

Re: $$Excel-Macros$$ Shortcut key for Border

2011-10-12 Thread sunil bn
Hi, Even to me 1st and 2nd is working rest all other is not applying... Pls help... Regards, Sunil B.N +91 9035 8585 85 On 13 Oct 2011 10:25, "Ankit Agrawal" wrote: > Dear All, > > I am trying but it is not doing.Plz help me to solve out it. > > Regards, > Ankit > > On 10/12/11, NOORAIN ANSARI

$$Excel-Macros$$ Macro's for Mricrosoftoutlook

2011-10-12 Thread sunil bn
Hi Expert, how to create a macro for Microsoft outlook. Eg.if i just run the macro the selected file should attached in new mail. -- *Regards* **Sunil B.N ***9035858585 -- -- Some important links for excel users: