$$Excel-Macros$$ Re: formula required query

2018-10-06 Thread Rajesh kumar
Hi , Please Check. I have attached excel. On Saturday, 6 October 2018 14:27:11 UTC+5:30, rajeyssh wrote: > > Dear Sir > Formula required as per the attachment in sheet "2". > Thanks in advance for your help. > > Regards > > -- > *Rajesh Kumar Agarwal* > *9811063001* > -- Are you =EXP(E:RT) or

$$Excel-Macros$$ Re: FORMULA REQUIRED

2015-10-26 Thread GENIUS
Thank you Mr Paul that's really great On Saturday, 24 October 2015 17:07:35 UTC+5, GENIUS wrote: > > Thanks for your reply, but let me clear as you may see if we put more data > in the rows we may have the sum of all the rows at one place, look at the > sheet, but i need only row wise sum not th

Re: $$Excel-Macros$$ Re: FORMULA REQUIRED

2015-10-26 Thread Paul Schreiner
le you can, As long as ever you can.” - John Wesley - From: GENIUS To: MS EXCEL AND VBA MACROS Sent: Saturday, October 24, 2015 8:07 AM Subject: $$Excel-Macros$$ Re: FORMULA REQUIRED Thanks for your reply, but let me clear as you may see if w

$$Excel-Macros$$ Re: FORMULA REQUIRED

2015-10-24 Thread GENIUS
Thanks for your reply, but let me clear as you may see if we put more data in the rows we may have the sum of all the rows at one place, look at the sheet, but i need only row wise sum not the sum of the different rows at one place i.e. if we sum row three in J3 and K3, the sum must be of row 3

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

2015-04-22 Thread mpatram
Did not understand your requirement. also, FYI, I can not see anything in this attachemnt. On Tuesday, April 21, 2015 at 11:03:22 PM UTC+5:30, rajeyssh wrote: > Hello Sir > formula required in both the column matching. > > -- > *Rajesh Kumar Agarwal* > *9811063001* > -- Are you =EXP(E:RT) o

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$$ Re: formula required to update values form one sheet to another sheet with date criteria

2013-07-19 Thread Probyn Cope
Not clear what you are trying to do but if your master sheet has different names and you are trying to sum for your report sheet try the following: =SUMIF(MASTER!$B$5:$B$35,"Raman Choudary",MASTER!C5:C35) That goes into B9 of your report sheet. You can then copy across. If B10 is a different

$$Excel-Macros$$ Re: formula required

2013-02-09 Thread Prince
Hi Ganesh, PFA. Regards Prince On Sunday, February 10, 2013 8:50:17 AM UTC+5:30, GANESH wrote: > > Hi I want the J8 show me the total of rim of which I highilighted in > Green color all the user in Column E > Column B has user Name Column c has the total of amount > Please find the at

Re: $$Excel-Macros$$ Re: formula required

2013-01-15 Thread Ms-Exl-Learner
@ Prince, Do you think is it a quality answer? and Dont you think you are re-directing the OP in wrong approach? =SUM(($D$2:D5=D2)**1**(G2:M2))*with CSE*in Cell "O2" Could you please explain what is the need of **1* *and what is the need ofCSE here* *why not then one (Non Array Approach)

Re: $$Excel-Macros$$ Re: formula required

2013-01-15 Thread Prince
der: * excel-...@googlegroups.com > *Date: *Sun, 13 Jan 2013 23:02:48 -0800 (PST) > *To: *> > *ReplyTo: * excel-...@googlegroups.com > *Subject: *$$Excel-Macros$$ Re: formula required > > Hi Prashant, > > I hope it may help you: > > =SUM(($D$2:D5=D2)*1*(G2:M2))

Re: $$Excel-Macros$$ Re: formula required

2013-01-15 Thread अनिल नारायण गवली
o: * > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *$$Excel-Macros$$ Re: formula required > > Hi Prashant, > > I hope it may help you: > > =SUM(($D$2:D5=D2)*1*(G2:M2)) with CSE in Cell "O2" > > Regards > Prince > > On Monday, January 14, 2013 1

Re: $$Excel-Macros$$ Re: formula required

2013-01-15 Thread viking4u
Loop Mobile. -Original Message- From: Prince Sender: excel-macros@googlegroups.com Date: Sun, 13 Jan 2013 23:02:48 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: formula required Hi Prashant, I hope it may help you: =SUM(($D$2:D5=D2)*1*(G2:M2)) with CSE in

$$Excel-Macros$$ Re: formula required

2013-01-13 Thread Prince
Hi Prashant, I hope it may help you: =SUM(($D$2:D5=D2)*1*(G2:M2)) with CSE in Cell "O2" Regards Prince On Monday, January 14, 2013 12:19:32 PM UTC+5:30, ppawle.excel wrote: > > Dear Team, > > Need a formula to look up a filed & give sum of figure , sample file > attached > > Regards, > > Pras

Re: $$Excel-Macros$$ Re: formula required for addition of amount for duplicate entry

2012-10-10 Thread ashish damor
Dear Sir, If possible can you please send me the example of the formula. On Wed, Oct 10, 2012 at 11:17 AM, Prince wrote: > Hi Ashish, > > Please use sumifs formula for getting total GROSS and TDS amount for each > vendor. > > Regards > Prince > > On Tuesday, October 9, 2012 1:16:22 PM UTC+5:30,

Re: $$Excel-Macros$$ Re: formula required for addition of amount for duplicate entry

2012-10-09 Thread ashish damor
Dear Sir, Thanks will try and get back to you. On Wed, Oct 10, 2012 at 11:17 AM, Prince wrote: > Hi Ashish, > > Please use sumifs formula for getting total GROSS and TDS amount for each > vendor. > > Regards > Prince > > On Tuesday, October 9, 2012 1:16:22 PM UTC+5:30, ashish damor wrote: >> >>

$$Excel-Macros$$ Re: formula required for addition of amount for duplicate entry

2012-10-09 Thread Prince
Hi Ashish, Please use sumifs formula for getting total GROSS and TDS amount for each vendor. Regards Prince On Tuesday, October 9, 2012 1:16:22 PM UTC+5:30, ashish damor wrote: > > Dear All, > > I have an excel sheet wherein commission is generated for each > business placed by our intermedi

$$Excel-Macros$$ Re: formula required for count or count if

2012-04-27 Thread Haseeb A
Hello Lee, This should work with just ENTER. in AC2, then drag down. =SUMPRODUCT((A$2:A$23=AB2)*(B$2:Z$23<>"")/COUNTIF(B$2:Z$23,B$2:Z$23&"")) Adjust the ranges. See the attached. Regards, Haseeb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread title

RE: $$Excel-Macros$$ Re: formula required for count or count if

2012-04-27 Thread Rajan_Verma
@googlegroups.com] On Behalf Of CoRe Sent: Apr/Fri/2012 12:58 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: formula required for count or count if Hello Lee, PFA! If you have any queries ,give a shout ... On Friday, April 27, 2012 7:30:32 AM UTC+3, lee wrote: hi i have data as

$$Excel-Macros$$ Re: Formula required

2008-11-17 Thread Samir Agayev
Hi, If you had this "+" sign in every contact I would suggest Data>Text to Column wizard in Excel. But in this situation there is no automatic solution, i think. On Fri, Nov 14, 2008 at 2:51 PM, Ahmedhonest <[EMAIL PROTECTED]> wrote: > Dear All Chill out Greetings for the Day, > > Please see the