Re: $$Excel-Macros$$ Formula for Month wise calculation

Dear Mr. Paul, It great to formulate such a amazing formula to calculate such difficult scenario. Abi Joseph On Fri, Sep 29, 2017 at 5:48 PM, Paul Schreiner wrote: > This is pretty "convoluted" logic. > I tried several approaches that soon became extremely complex (as if this > isn't?) > > Th

Re: $$Excel-Macros$$ Formula for Month wise calculation

Dear Mr. Paul, Thanks :) *Regards,* *For quick responds click here for Message * On Fri, Sep 29, 2017 at 3:18 PM, Paul Schreiner wrote: > This is pretty "convoluted" logic. > I tried several approaches that soon became extremely complex (as if this > isn't?) > > The approach is this: > Estab

Re: $$Excel-Macros$$ Formula for Month wise calculation

This is pretty "convoluted" logic.I tried several approaches that soon became extremely complex (as if this isn't?) The approach is this:Establish a starting date of 01-Jan of LAST yearand an Ending Date of -1-Jan of NEXT year.(I could've hard-coded these dates, but then you'd have to edit the m

Re: $$Excel-Macros$$ Formula to convert Text into Number

On Fri, 4/7/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 2017

Re: $$Excel-Macros$$ Formula to convert Text into Number

On Fri, 4/7/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 2017

Re: $$Excel-Macros$$ Formula to convert Text into Number

On Fri, 4/7/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 2017

Re: $$Excel-Macros$$ Formula to convert Text into Number

On Fri, 4/7/17, 'Keisha Fry' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 201

Re: $$Excel-Macros$$ Formula to convert Text into Number

On Fri, 4/7/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 201

Re: $$Excel-Macros$$ Formula to convert Text into Number

On Fri, 4/7/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 201

Re: $$Excel-Macros$$ Formula to convert Text into Number

Hi Please review and do let me know if anything else required. Regards DD On Thu, Apr 6, 2017 at 3:09 PM, Secret Shot wrote: > Hi Experts, > > I am stuck with one problem. I have one file which have numbers in it. but > while capturing they got stored as Text. > > Now i want any formula to co

Re: $$Excel-Macros$$ Formula to convert Text into Number

Hi, Please review and revert if anything else required. Regards DD On Thu, Apr 6, 2017 at 3:09 PM, Secret Shot wrote: > Hi Experts, > > I am stuck with one problem. I have one file which have numbers in it. but > while capturing they got stored as Text. > > Now i want any formula to convert in

Re: $$Excel-Macros$$ Formula to convert Text into Number

On Fri, 4/7/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 201

Re: $$Excel-Macros$$ Formula to convert Text into Number

On Fri, 4/7/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 201

Re: $$Excel-Macros$$ Formula to convert Text into Number

On Thu, 4/6/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Thursday, April 6, 201

Re: $$Excel-Macros$$ Formula to convert Text into Number

On Thu, 4/6/17, 'Martin George' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Thursday, April 6, 201

Re: $$Excel-Macros$$ Formula to convert Text into Number

On Thu, 4/6/17, jmothilal wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Thursday, April 6, 2017, 1:36 PM first letter is not zero  is "O" , so Remove the first

Re: $$Excel-Macros$$ Formula to convert Text into Number

Dear Pankaj G, Please check your solved query. if any issue , let me know. On Thu, Apr 6, 2017 at 3:09 PM, Secret Shot wrote: > Hi Experts, > > I am stuck with one problem. I have one file which have numbers in it. but > while capturing they got stored as Text. > > Now i want any formula to co

Re: $$Excel-Macros$$ Formula to convert Text into Number

first letter is not zero is "O" , so Remove the first letter "O", On Thu, Apr 6, 2017 at 3:09 PM, Secret Shot wrote: > Hi Experts, > > I am stuck with one problem. I have one file which have numbers in it. but > while capturing they got stored as Text. > > Now i want any formula to convert into

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

On Wed, 2/8/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula help needed To: excel-macros@googlegroups.com Date: Wednesday, February 8, 2017, 8:30 PM

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

On Wed, 2/8/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula help needed To: excel-macros@googlegroups.com Date: Wednesday, February 8, 2017, 3:01 PM On

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

On Wed, 2/8/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Formula help needed To: "excel-macros@googlegroups.com" Date: Wednesday, February 8, 2017, 2:29 PM The Match() function will return the relative column for the dat

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

The Match() function will return the relative column for the date matching the header.So: Your array of data is in E1:AI1 and if you're looking for the date in cell C1, you would use:MATCH(C$1,$E$1:$AI$1)(the "$" will be necessary for when you copy the formulas) In this case, the function return

Re: $$Excel-Macros$$ Formula Problem

Thanks for reply sir but if i'm not using any helping column then. On Fri, Aug 12, 2016 at 2:02 AM, Murali Nagarajan wrote: > Dear Sourav, > > I hope you are doing great. > > Regards > N.Murali > > On Thu, Aug 11, 2016 at 6:41 PM, sourav devrani < > souravdevrani1...@gmail.com> wrote: > >> Hey g

Re: $$Excel-Macros$$ Formula Problem

Dear Sourav, I hope you are doing great. Regards N.Murali On Thu, Aug 11, 2016 at 6:41 PM, sourav devrani wrote: > Hey guys, > I need your help. > Please see the attached file. > Regards > Sourav Devrani > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And d

Re: $$Excel-Macros$$ formula proble

Thank you very much for your quick reply and correction of formula once again thank you very much -- 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

Re: $$Excel-Macros$$ formula proble

Hi Izhar, Check the attachment, if may help you. in your formula you were trying to match the max number with student list instead of random numbers. Faisal PK On Sun, Jul 24, 2016 at 2:47 PM, Izhar wrote: > PLEASE SEE THE QUESTION IN THE FILE > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

Re: $$Excel-Macros$$ formula required

According to the condition the formula is perfect but if you have few more minutes can you please explain this formula thank you very much for this -- 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 @ ht

Re: $$Excel-Macros$$ formula required

try enclosed one -- Thanks & Regards, Sunny Chauhan E-Mail :- sunnyc...@gmail.com , 9540025528, On Sun, Jul 10, 2016 at 2:17 PM, Izhar wrote: > I need formula in cell C10:C14 > Please check the conditions > Thanks in advance > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do yo

Re: $$Excel-Macros$$ Formula for Conditional Formatting

Please find the attached file :) On Sun, Jun 26, 2016 at 12:27 PM, vikas khen wrote: > Hi Team, > > Please find the attached sheet in which i need if the status value (is J > column) Open it should highlight entire row by red color. > > A waiting for your reply on this > > Regards > > -- > Are yo

Re: $$Excel-Macros$$ Formula required

Its working fine. Thanks for the help. Regards Rajesh Agarwal On Thursday, June 23, 2016 at 9:50:57 AM UTC+5:30, a.gowri wrote: > > ​you can try this, > > 1 > =SUM(IF(RANK($A$2:$A$21,$A$2:$A$21,1)=(RANK($B$21,$A$2:$A$21,1)-1),$A$2:$A$21)) > 2 > =SUM(IF(RANK($A$2:$A$21,$A$2:$A$21,1)=(RANK($B$21

Re: $$Excel-Macros$$ Formula required

​you can try this, 1 =SUM(IF(RANK($A$2:$A$21,$A$2:$A$21,1)=(RANK($B$21,$A$2:$A$21,1)-1),$A$2:$A$21)) 2 =SUM(IF(RANK($A$2:$A$21,$A$2:$A$21,1)=(RANK($B$21,$A$2:$A$21,1)-2),$A$2:$A$21)) 3 =SUM(IF(RANK($A$2:$A$21,$A$2:$A$21,1)=(RANK($B$21,$A$2:$A$21,1)+1),$A$2:$A$21)) 4 =SUM(IF(RANK($A$2:$A$21,$A$2:$A

Re: $$Excel-Macros$$ Formula required

IF YOU SORT YOUR DATAthen you can use the MATCH() function to find the row number that matches the value in cell B21.Using this value, you can then use the index() function to return the values 1 and 2 rows from that cell.Like: C21: =INDEX(A2:A21,MATCH(B21,A2:A21)-1) D21: =INDEX(A2:A21,MATCH(B21

Re: $$Excel-Macros$$ Formula required

formula required as mentioned in column D19. On Friday, June 17, 2016 at 6:28:10 PM UTC+5:30, Vikas Verma wrote: > > plz provide more clearity?? about your query > > Thanks & regards, > > www.MrExcel4U.com > > On Fri, Jun 17, 2016 at 5:26 AM, Rajesh Agarwal >

Re: $$Excel-Macros$$ Formula required

plz provide more clearity?? about your query Thanks & regards, www.MrExcel4U.com On Fri, Jun 17, 2016 at 5:26 AM, Rajesh Agarwal wrote: > Dear Sir > > please help me by resolving the issue. > > -- > *Rajesh Kumar Agarwal* > *9811063001* > > -- > Are you =EX

Re: $$Excel-Macros$$ Formula required

Hi, PFA On 17 June 2016 at 17:56, Rajesh Agarwal wrote: > Dear Sir > > please help me by resolving the issue. > > -- > *Rajesh Kumar Agarwal* > *9811063001 <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 Face

Re: $$Excel-Macros$$ Formula for Sum of nearest target value

hi experts. On Mon, Apr 18, 2016 at 7:22 AM, Dheeraj Bankoti wrote: > > It seems now there is no excitement in group to help. > > Regards > Dheeraj > > -- Forwarded message -- > From: Dheeraj Bankoti > Date: Sat, Apr 16, 2016 at 11:53 AM > Subject: Fwd: $$Excel-Macros$$ Formula

Re: $$Excel-Macros$$ Formula to extract date from cell

Can anyone pls help me into this... On Apr 4, 2016 2:57 PM, "Secret Shot" wrote: > Dear Experts, > > I have some text in a cell like "Date Range: 3/31/16 - 3/31/16" > > I want to extract the date in a another cell like date not as text only. > > Can any one help me with any dynamic formula which

Re: $$Excel-Macros$$ Formula to take the value depends upon the two values

It works on all criteria at my end. Please see that you are entering characters without any spaces (before or after). Try copy pasting the characters for understanding. On Thu, Nov 5, 2015 at 7:01 PM, big smile wrote: > If i put 1A instead of A then it works > > On Thu, Nov 5, 2015 at 6:55 PM,

Re: $$Excel-Macros$$ Formula to take the value depends upon the two values

If i put 1A instead of A then it works On Thu, Nov 5, 2015 at 6:55 PM, big smile wrote: > Thanks a lot > > But if i put Table A then it shows 0 only. For Table A -- Both Risk Group > I /II not work.. > > On Thu, Nov 5, 2015 at 6:49 PM, Abhishek Jain > wrote: > >> PFA >> >> On Thu, Nov 5, 2015

Re: $$Excel-Macros$$ Formula to take the value depends upon the two values

Thanks a lot But if i put Table A then it shows 0 only. For Table A -- Both Risk Group I /II not work.. On Thu, Nov 5, 2015 at 6:49 PM, Abhishek Jain wrote: > PFA > > On Thu, Nov 5, 2015 at 6:20 PM, big smile wrote: > >> Repected Friends 1] Which formula I should use in E 13 --- I want the

Re: $$Excel-Macros$$ Formula to take the value depends upon the two values

PFA On Thu, Nov 5, 2015 at 6:20 PM, big smile wrote: > Repected Friends 1] Which formula I should use in E 13 --- I want the > value depends upon Risk Group & Table As per B4 :D9 2] First I have to > see the Group which I & II then Table A/B/C/D It will take depends upon > this two criteria

Re: $$Excel-Macros$$ FORMULA REQUIRED

Are you saying that you are expecting multiple rows of data:(row 3-100) and you want the Total Unit cell to be calculated from the total of all cells in column A, C, E and G? and the Cost total to be columns B, D, F and H? If so, then you can use:=SUM(A:A)+SUM(C:C)+SUM(E:E)+SUM(G:G)and=SUM(B:B)+

Re: $$Excel-Macros$$ formula for compound interest

http://www.excel-easy.com/examples/compound-interest.html On Sat, Sep 19, 2015 at 11:29 AM, Rajesh Agarwal wrote: > Rs. 1/- > rate of interest 12% > compound half yearly, quartly, monthly for the period of > 1. 15 months > 2. 267 days > > -- > *Rajesh Kumar Agarwal* > *9811063001*

Re: $$Excel-Macros$$ Formula needed

Dear Abhishek Really great problem solved. thanks a lot Regards Shrinivas On Fri, Aug 28, 2015 at 12:45 PM, Abhishek Jain wrote: > Hope this helps. > > Whenever you want to make any change in the formula, do it in the first > resulting value, i.e, G2 and remember to press Ctrl+Shift+Enter (not

Re: $$Excel-Macros$$ Formula needed

Hope this helps. Whenever you want to make any change in the formula, do it in the first resulting value, i.e, G2 and remember to press Ctrl+Shift+Enter (not just enter) before dragging it down. Regards, On Fri, Aug 28, 2015 at 12:06 PM, Shrinivas Shevde wrote: > Dear All > Please find query.

Re: $$Excel-Macros$$ Formula to Calculate Slab Wise Commission as per Targets Achieved

See this for simple formula solution. Lear More@ www.ExcelVbaLab.Com On Thursday, August 20, 2015 at 12:02:41 PM UTC+5:30, Ashok Soni wrote: > > Dear Pankaj Sharma, > thanks of lot, i will make it on other sheet. > i had sent it ( incentive slab for example to understand what i am looking > )

Re: $$Excel-Macros$$ Formula to Calculate Slab Wise Commission as per Targets Achieved

Dear Pankaj Sharma, thanks of lot, i will make it on other sheet. i had sent it ( incentive slab for example to understand what i am looking ) your formula is best way for me, if i need more help regarding this i will disturb you again. thanks again On Thu, Aug 20, 2015 at 10:56 AM, Pankaj Sharma

Re: $$Excel-Macros$$ Formula to Calculate Slab Wise Commission as per Targets Achieved

Dear Ashok, I don't think there is any easiest way to calculate this with excel formula's. You can do with run a macro or better if you make a slab chart on the right side or other sheet to calculate the same. This will be easy if you have to change slab criteria in future. On Wed, Aug 19, 20

Re: $$Excel-Macros$$ Formula to Calculate Slab Wise Commission as per Targets Achieved

Dear Rajan Sir, I need a formula in excel which can calculate commission on target amount. i describe as bellow: 1. suppose i have 10 branches and more than 3 employee in each. 2. i have different % slab of commission. 3. commission should be calculate stab by stab. i have explain it in excel

Re: $$Excel-Macros$$ FORMULA REQUIRED

Thank you very much for your quick response, I really appreciate it. once again thank you for your help On Thursday, 30 July 2015 20:43:01 UTC+5, Pankaj Sharma wrote: > > use this > > =INDEX($L$2:$R$87,MATCH($B2,$K$2:$K$87,0),MATCH($C2,$L$1:$R$1,0)) > > or > > if you don't want to see #N/A error

Re: $$Excel-Macros$$ FORMULA REQUIRED

use this =INDEX($L$2:$R$87,MATCH($B2,$K$2:$K$87,0),MATCH($C2,$L$1:$R$1,0)) or if you don't want to see #N/A error so use this one =IFERROR(INDEX($L$2:$R$87,MATCH($B2,$K$2:$K$87,0),MATCH($C2,$L$1:$R$1,0)),"-") *Regards,* *PJ* On Thu, Jul 30, 2015 at 8:01 PM, Izhar wrote: > I need fig

Re: $$Excel-Macros$$ Formula to Display Latest PO number Using date and emp ID

Hi Van, Excellent sample, Thanks. Eugene On Wed, Jul 22, 2015 at 12:47 AM, Bé Trần Văn wrote: > B3 selected in the drop down list, View Results. > > 2015-07-21 19:08 GMT+07:00 Paul Schreiner : > >> First: >> Your EMP ID field is mixed with "text" and "numbers". >> Probably because this list wa

Re: $$Excel-Macros$$ Formula to Display Latest PO number Using date and emp ID

B3 selected in the drop down list, View Results. 2015-07-21 19:08 GMT+07:00 Paul Schreiner : > First: > Your EMP ID field is mixed with "text" and "numbers". > Probably because this list was imported from another source. > (generated a report as a text file and opened it in Excel?) > > then, if y

Re: $$Excel-Macros$$ Formula to Display Latest PO number Using date and emp ID

First:Your EMP ID field is mixed with "text" and "numbers".Probably because this list was imported from another source.(generated a report as a text file and opened it in Excel?) then, if you click in one of the cells, or remove spaces, or interact with the cell in several other ways, Excel rein

Re: $$Excel-Macros$$ Formula for auto generated code

Dear All, Hope all of you are well. I need for a formula which can generate codes series automatically. Like I have a code series 1040004500 when I have press TAB then the series code like that 1040004600..mean 45 convert into 46. On May 31, 2015 9:45 PM, "Ali Abbas" wrote: > Dear All, >

Re: $$Excel-Macros$$ formula required

Author need formula & i guess this is already answered for similar question.. On Sun, May 3, 2015 at 7:37 PM, Rajesh Agarwal wrote: > please provide me the formula. > > -- > *Rajesh Kumar Agarwal* > *9811063001* > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >

Re: $$Excel-Macros$$ formula required

PFA... On Fri, Apr 3, 2015 at 12:06 PM, Rajesh Agarwal wrote: > Hi > Required formula in B1 > > -- > 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 @ > h

Re: $$Excel-Macros$$ Formula required

Check this... On Tue, Mar 31, 2015 at 12:43 PM, Dhaval Shah wrote: > PFA > > Warm Regards, > > Dhaval Shah > M) 98240 35253 > *E-mail : todhavals...@gmail.com * > > > -- > 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 pa

Re: $$Excel-Macros$$ Formula based on some criteria

gt; Date: Fri, Mar 13, 2015 at 10:08 AM > Subject: Re: $$Excel-Macros$$ Formula based on some criteria > To: excel-macros@googlegroups.com > > > Dear gaurav, > > required some more modification. if you can check AED in question sheet is > 15 then in Master sheet, search for

Re: $$Excel-Macros$$ Formula based on some criteria

> > Thanks, > Rameshwari > -- Forwarded message -- > From: rameshwari shyam > > Date: Fri, Mar 13, 2015 at 10:08 AM > Subject: Re: $$Excel-Macros$$ Formula based on some criteria > To: excel-...@googlegroups.com > > > Dear gaurav, > > requir

Re: $$Excel-Macros$$ Formula Needed Please

please check the attachment On Fri, Mar 13, 2015 at 11:58 AM, Will Sob wrote: > > Hi, > Please I need help with the attached file. I want a that calculates how > many times 10, 13, 17 has appeared within the range D5:I32 > > > > > > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wan

Re: $$Excel-Macros$$ Formula based on some criteria

Dear gaurav, required some more modification. if you can check AED in question sheet is 15 then in Master sheet, search for 15 SAR. Below than that there is a AED 15, KWD 15, SAR 1.5 OMR 1.5 BHD 15 QAR 1.25, Base currency will be AED in question sheet and in master sheet base currency will be SAR

Re: $$Excel-Macros$$ Formula based on some criteria

Hi Rameshwari , Please check the file. Let me know if it does not work for you. Regards Gaurav Devrani On Thu, Mar 12, 2015 at 5:47 PM, Rameshwari wrote: > Hello team, > > I stuck with one formula, please help me on this. Formula based on some > criteria. > > > > Sheet “Question” having curre

Re: $$Excel-Macros$$ Formula to populate cells and sum in adjacent cell

Try this in B5 of sheet2 and drag right. =IF((COLUMN()-1)<=Sheet1!$B$3,Sheet1!$B$2,IF((COLUMN()-1)=Sheet1!$B$3+1,SUM(OFFSET($A$5,,1,,Sheet1!$B$3)),"")) On Mon, Feb 23, 2015 at 7:29 AM, Gaurav Devrani wrote: > Yes Sure.. I will get back to you with that formula. No worries. > > Regards > Gaurav

Re: $$Excel-Macros$$ Formula to populate cells and sum in adjacent cell

Yes Sure.. I will get back to you with that formula. No worries. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 7:25 AM, Enock Wangila wrote: > Hi Gaurav, > > Thank you for you help. Quick question, is there a way of using a formula > instead of a code to do what you have done. Maybe an If stat

Re: $$Excel-Macros$$ Formula to populate cells and sum in adjacent cell

Hi Gaurav, Thank you for you help. Quick question, is there a way of using a formula instead of a code to do what you have done. Maybe an If statement of some sort. Would appreciate if that were possible. I really need a formula. On Mon, Feb 23, 2015 at 4:42 PM, Gaurav Devrani wrote: > Hi , > >

Re: $$Excel-Macros$$ Formula to populate cells and sum in adjacent cell

Hi , I guess you also want to merge the header cells in sheet 2 for all entries.. Please refer to this new sheet. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 6:19 AM, Gaurav Devrani wrote: > HI Enock, > > Please check the attached file and let me know if I missed something. > > Regards

Re: $$Excel-Macros$$ Formula to populate cells and sum in adjacent cell

HI Enock, Please check the attached file and let me know if I missed something. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 5:08 AM, Enock Wangila wrote: > Hi Guys, > > I want a formula that populates values in a worksheet, on a single row > based on two values entered on a different worksh

Re: $$Excel-Macros$$ Formula to find the month btwn the financial year

cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Nov 26, 2014 at 11:36 AM, Ganesh N wrote: > Thanks bro!! > > On Wed, Nov 26, 2014 at 10:45 AM, Vaibhav Joshi wrote: > >> hi >> >> when you multiply by 1, xl converts it to date. >> >> Try this in excel,

Re: $$Excel-Macros$$ Formula to find the month btwn the financial year

Thanks bro!! On Wed, Nov 26, 2014 at 10:45 AM, Vaibhav Joshi wrote: > hi > > when you multiply by 1, xl converts it to date. > > Try this in excel, put this formula cell E2 =DATE(20&RIGHT(D2,2),3,31), > now goto format cell & change date format to dd/mmm/yy or any other format, > result wont cha

Re: $$Excel-Macros$$ Formula to find the month btwn the financial year

hi when you multiply by 1, xl converts it to date. Try this in excel, put this formula cell E2 =DATE(20&RIGHT(D2,2),3,31), now goto format cell & change date format to dd/mmm/yy or any other format, result wont change. Now in next celll put formula =E2*1 & now goto format cell & change date form

Re: $$Excel-Macros$$ Formula to find the month btwn the financial year

Thanks Vaibhav ji, Got it. But can you pls explain how this works =DATE(20&RIGHT(D2,2),3,31)*1 Thanks a lot! Regards, Ganesh N On Tue, Nov 25, 2014 at 8:17 PM, Vaibhav Joshi wrote: > hi > > check this... > > In blue i have given formula using helper columns & in yellow its direct > one.. > > C

Re: $$Excel-Macros$$ Formula to find the month btwn the financial year

hi check this... In blue i have given formula using helper columns & in yellow its direct one.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Nov 21, 2014 at 4:50 PM, Ganesh N wrote: > Dear Mandeep, > > Please see the header I mean the financial y

Re: $$Excel-Macros$$ Formula to find the month btwn the financial year

Dear Mandeep, Please see the header I mean the financial year if it is FY 15-16 that means I what to find the month in apr 15- Mar 16 in the given time period "1 april and 30 june 19". Im I clear or need more clarification ? Thanks & Regards, Ganesh N On Fri, Nov 21, 2014 at 3:30 PM, Mandeep B

Re: $$Excel-Macros$$ Formula to find the month btwn the financial year

How can be the no of months between 1 april and 30 june 19 is 12 ? what you are saying. Regards, Mandeep baluja *Month**End Month**FY 15-16**FY 16-17**FY 17-18**FY 18-19**FY 19-20**FY 20-21* *1-Apr-15**30-Jun-19**12**12**12**12**3**0* On Friday, November 21, 2014 3:27:20 PM UT

Re: $$Excel-Macros$$ Formula to find the month btwn the financial year

Dear team, Any update on the request ? Thanks & Regards, Ganesh N On Fri, Nov 21, 2014 at 2:14 PM, Ganesh N wrote: > I tried but I not able to find the exact month btwn the year... So I need > the help on that... > > Regards, > Ganesh N > > On Fri, Nov 21, 2014 at 2:07 PM, Hilary Lomotey wrot

Re: $$Excel-Macros$$ Formula to find the month btwn the financial year

I tried but I not able to find the exact month btwn the year... So I need the help on that... Regards, Ganesh N On Fri, Nov 21, 2014 at 2:07 PM, Hilary Lomotey wrote: > USE DATEDIF FUNCTION > > On Fri, Nov 21, 2014 at 7:55 AM, Ganesh N wrote: > >> Dear team, >> >> Need a help on formula to fin

Re: $$Excel-Macros$$ Formula to find the month btwn the financial year

USE DATEDIF FUNCTION On Fri, Nov 21, 2014 at 7:55 AM, Ganesh N wrote: > Dear team, > > Need a help on formula to find the month btwn the years.. pls find the > attachement. > > Note: its should calculate from Apr - Mar > > I tried but I not able to get the correct one. > > Thanks & Regards, > Ga

Re: $$Excel-Macros$$ Formula Help !

Check this if it helps... Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Nov 8, 2014 at 6:10 PM, Ajay AJ wrote: > ​​ > Hey, > > So the basic concept is that he dates are for PPM Schedule so which means > whenever it was left off, it has to be done

Re: $$Excel-Macros$$ Formula Required

Cheers!! On Thu, Jul 10, 2014 at 12:17 PM, amar takale wrote: > thanks vabs brother > > On Tue, Jul 8, 2014 at 10:33 PM, Vaibhav Joshi wrote: > > Hi > > > > Check this.. cell in green is what you want.. > > > > Cheers!! > > > > > > On Tue, Jul 8, 2014 at 7:14 PM, amar takale > wrote: > >> > >

Re: $$Excel-Macros$$ Formula Required

thanks vabs brother On Tue, Jul 8, 2014 at 10:33 PM, Vaibhav Joshi wrote: > Hi > > Check this.. cell in green is what you want.. > > Cheers!! > > > On Tue, Jul 8, 2014 at 7:14 PM, amar takale wrote: >> >> Dear experts >> >> I want date formula.I try it but with 2 cell help but I think it is >> n

Re: $$Excel-Macros$$ Formula Required

I'm sorry, but your explanation is confusing. Can you give an example?   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you c

Re: $$Excel-Macros$$ formula issue

Hi Attachment is missing.. Thx On Mon, Apr 28, 2014 at 7:14 PM, L.K. Modi wrote: > Dear Sir > > I have downloaded a file from the net but unable to understand the logic > in column Q AND R as the file is read only only so can anyone say me how > that delay had been calculated and interest is

Re: $$Excel-Macros$$ formula issue with sample sheet

Hi Modi, Im not clear with Defaults month (column Q) because it does not match with due date and payment day. But Defaults Interest (column R) is calculate by if *defaults months*greater than 0 then *TDS amount * 1.5% * defaults months* else the defaults interest will be *0*. (=if(defaultsmonth>0

Re: $$Excel-Macros$$ Formula help

=IF(AND(C7>=C2,C7<=D2),E2,IF(AND(C7>=C3,C7<=D3),E3,IF(AND(C7>=C4,C7<=D4),E4,0))) On Mon, Jan 20, 2014 at 11:08 AM, Shaikh Iqbal wrote: > Thx sir. I need IF condition formula. > > > > > > > On 18 January 2014 21:17, Kantilal Badale wrote: > >> PFA >> >> CA Kantilal Badale >> 9822250393 >> >> >> >

Re: $$Excel-Macros$$ Formula help

Thx sir. I need IF condition formula. On 18 January 2014 21:17, Kantilal Badale wrote: > PFA > > CA Kantilal Badale > 9822250393 > > > > On Sat, Jan 18, 2014 at 5:08 PM, Shaikh Iqbal wrote: > >> Dear Export, >> >> >> I want a formula as per attached 3 slab condition wise earning. >> >> >> >

Re: $$Excel-Macros$$ Formula help

PFA CA Kantilal Badale 9822250393 On Sat, Jan 18, 2014 at 5:08 PM, Shaikh Iqbal wrote: > Dear Export, > > > I want a formula as per attached 3 slab condition wise earning. > > > > > > > > > > > > > > Regards, > > Iqbal > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

RE: $$Excel-Macros$$ formula query

May be you r looking for this. =IF(AND(A90),A9,B8) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajesh Agarwal Sent: Monday, December 16, 2013 4:01 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ formula query -- Rajesh Kumar

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

Hi Rajesh Please find the attachment. Is this what you are looking for? On Tue, Dec 3, 2013 at 3:53 AM, Rajesh Agarwal wrote: > > > -- > *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 officia

Re: $$Excel-Macros$$ Formula for averaging readings in Excel 2010 column, the odd and the even numbered cells

Its ok You can also try averageif function Sent on my BlackBerry® from Vodafone -Original Message- From: Noel Sherry Sender: excel-macros@googlegroups.com Date: Wed, 27 Nov 2013 22:58:45 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula for averaging

Re: $$Excel-Macros$$ Formula for averaging readings in Excel 2010 column, the odd and the even numbered cells

Ashish, I just double checked and that works like a charm. Thanks so much. I really searched for a formula and tried 8 to 10 I found, but none worked. This is perfect. Wow, this forum is amazing. I will have other questions as I continue to use Excel. Should I check this as completed? Noel On W

Re: $$Excel-Macros$$ Formula for averaging readings in Excel 2010 column, the odd and the even numbered cells

That looks good, compared to the ones I have found on the Internet. I will plug this in and try it. Thanks, Noel On Wed, Nov 27, 2013 at 10:28 PM, ashish koul wrote: > =SUMIFS($D$2:$D$63,$C$2:$C$63,"*pm")/COUNTIF($C$2:$C$63,"*pm*") > > use same for am > > > On Thu, Nov 28, 2013 at 8:53 AM, Noel

Re: $$Excel-Macros$$ Formula for averaging readings in Excel 2010 column, the odd and the even numbered cells

=SUMIFS($D$2:$D$63,$C$2:$C$63,"*pm")/COUNTIF($C$2:$C$63,"*pm*") use same for am On Thu, Nov 28, 2013 at 8:53 AM, Noel Sherry wrote: > Sure Ashish, > That was a quick response. I just joined this forum and posted my > question. I have put a sample Excel attached to this to show the problem. > T

Re: $$Excel-Macros$$ Formula for averaging readings in Excel 2010 column, the odd and the even numbered cells

Sure Ashish, That was a quick response. I just joined this forum and posted my question. I have put a sample Excel attached to this to show the problem. The first column is the date, second column the day, third the time, the morning or AM reading in the even numbered cells of column D (4th column)

Re: $$Excel-Macros$$ Formula for averaging readings in Excel 2010 column, the odd and the even numbered cells

even number byr row or value can u share a sample file On Thu, Nov 28, 2013 at 8:43 AM, wrote: > > > I am working on a DMin, for Bethel Seminary, and am trying to find a > formula to average the even and the odd numbered cells or rows in an Excel > 2010 column of blood pressure readings, the ev

Re: $$Excel-Macros$$ Formula to fetch employee names based on time

Dear Kartik, Thanks for your reply. All I want is when I select the timezone and the day, the employees working through the day would appear along with times. Let me know if any further clarification is needed. Regards...Abhishek On Mon, Nov 18, 2013 at 5:27 PM, Kartik Dale wrote: > Hi Abhi

Re: $$Excel-Macros$$ Formula to fetch employee names based on time

Hi Abhishek, Can you please be more clear on your request, so that we can try to solve your query Regards, Kartik On Wed, Nov 13, 2013 at 10:16 AM, Abhishek Jain wrote: > Friends, > > > I have a file, wherein I have times when employees are scheduled to > work. These times are in PST. > > I ha

Re: $$Excel-Macros$$ Formula require for Conditional and Lookup data

attachment missing . Enjoy Team XLS On Thu, Nov 14, 2013 at 9:46 AM, Rajan sharma wrote: > Dear experts, > > > I am unable to write the formula for the attached excel file. > Please help me to create formula please..i have tried many a times, but > unable to w

Re: $$Excel-Macros$$ Formula require for Conditional and Lookup data-

Dear Sirs, I want to find the Closest match from A and D column. i mean if the word contains in A column similar to D column (it may be 1st , 2nd or any middle line or last line) then the closest matches should be lookup. I hope i could able to explain you all experts, Thanks to all for

Re: $$Excel-Macros$$ Formula require for Conditional and Lookup data-

Dear rajan, Pl elaborate more on this query Warm Regards, Gawli Anil Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Thu, Nov 14, 2013 at 11:57 AM, Rajan sharma wrote: > Dear all experts, > > Is my query is valid ? can we lookup the closes

  1   2   3   4   5   >