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