Re: $$Excel-Macros$$ Re: formula required in column c excluding Zero

2015-04-21 Thread Chandan Bisht
Hi i think your are looking for this..file also attached =IFERROR(SMALL($B$2:$B$375,COUNTIF($B$2:$B$375,"<=0")+ROW(A1)),"") Thankx & Rgds, Chandra Singh Bisht On Wed, Apr 22, 2015 at 10:11 AM, Rajesh Agarwal wrote: > Sorry. now find the attachment. > > On Tue, Apr 21, 2015 at 10:53 PM, Raj

Re: $$Excel-Macros$$ Re: formula required in column c excluding Zero

2015-04-21 Thread Ashish Kumar
Elaborate more!! Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, l

$$Excel-Macros$$ Re: formula required in column c excluding Zero

2015-04-21 Thread Rajesh Agarwal
Sorry. now find the attachment. On Tue, Apr 21, 2015 at 10:53 PM, Rajesh Agarwal wrote: > Hello Sir > formula required > > -- > *Rajesh Kumar Agarwal* > *9811063001* > -- *Rajesh Kumar Agarwal* *9811063001* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME

$$Excel-Macros$$ formula required in column D & E

2015-04-21 Thread Rajesh Agarwal
Hello Sir formula required in both the column matching. -- *Rajesh Kumar Agarwal* *9811063001* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1)

$$Excel-Macros$$ formula required in column c excluding Zero

2015-04-21 Thread Rajesh Agarwal
Hello Sir formula required -- *Rajesh Kumar Agarwal* *9811063001* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2015-04-21 Thread Jeffrey DeAnna
Does this function as an autocomplete for drop down validation lists? I've been looking forever for a solution but I am beginning to lose hope. I need it to function without using combobox. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Joi

$$Excel-Macros$$ Send Email to Persons in a column Range

2015-04-21 Thread Hilary Lomotey
Hello Experts, i have attached an excel sheet which copies a portion of an excel worksheet and attaches it to an outlook mail which is perfect however, i want an additional code o modify this existing code to send email to a people in a range, eg in the attached sheet send email to address in colu

Re: $$Excel-Macros$$ freshser exel traning

2015-04-21 Thread Prabhu Pinky
Hi. Please visit www.w3schools.com Very useful website for beginers. On 21-Apr-2015 1:16 PM, "yadramharsana" wrote: > Dear, > all of my freds are the list .I ma a fresher of exel & i know > the basic of exel but i want to know about mis executive report and full > knowledge of ms exc

$$Excel-Macros$$ Re: freshser exel traning

2015-04-21 Thread Nasir Saikh
Dude Join classes to become Expert in MS Office. On Tuesday, April 21, 2015 at 1:16:37 PM UTC+5:30, yadramharsana wrote: > > Dear, > all of my freds are the list .I ma a fresher of exel & i know > the basic of exel but i want to know about mis executive report and full > knowle

$$Excel-Macros$$ freshser exel traning

2015-04-21 Thread yadramharsana
Dear, all of my freds are the list .I ma a fresher of exel & i know the basic of exel but i want to know about mis executive report and full knowledge of ms excel plz help me -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join