$$Excel-Macros$$ Formula required

Hello Group Members Will you help me to put formula in column E & F in the attached file as mentioned in column H. I will be very thankful to you for the same. -- 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

$$Excel-Macros$$ formula help

Dear All, I have attached one files need your help to applied correct formula Kindly help. Regards, Ganeshan -- 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

$$Excel-Macros$$ formula required query

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 =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 @

$$Excel-Macros$$ Formula has me stumped

I need a formula to equally divide a number from column A across a variable number of cells ( could be any number of cells from from 1 to 52). The starting column could also be variable from Column B to Column ZZ, and the ending column could be the same as the starting column and go as far as

Fwd: $$Excel-Macros$$ Formula needed

Hi All, Awaiting for your help on formula. Thanks, Kaushik Savla -- Forwarded message - From: KAUSHIK SAVLA Date: Wed, Sep 5, 2018 at 8:06 PM Subject: $$Excel-Macros$$ Formula needed To: MS EXCEL AND VBA MACROS KAUSHIK SAVLA [image: Attachments]1:53 PM (6 hours ago

$$Excel-Macros$$ Formula needed

KAUSHIK SAVLA [image: Attachments]1:53 PM (6 hours ago) to excel-macros Hi team, Need an formula whick will look at each cell of Column A and Column B and fetch result Criteria as below:- if Account beginning with 1 and if have balance positive then OK, otherwise "To check" if Account

$$Excel-Macros$$ Formula to Extract or Retrieve

Please need your help in creating a formula which will do the following Would like to extract this value 48-50 based on the criteria 2 found within the range Q21:AJ21. Would like a formula retrieve 48-50 in this format from the range Q21:AJ21 based on the criteria 2 on column AL21 found in the

$$Excel-Macros$$ Formula with retrieving squential data

Need your help in creating a formula which would do following:- To retrieve the value 18-19 from the range list B9:F14 to be stored in I10 To retrieve the value 40-41 from the range list B9:F14 to be stored in I11 To retrieve the value 11-12 from the range list B9:F14 to be stored in I13 Please

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

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

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

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

Hi All, Request to all of you that kindly find the attached sheet and help me to calculate Month wise cost by selecting the month and how to represent the same in piot table too. your assistance in this regards will be highly appreciated Thank you *Regards,* *Vikhen* -- Are you =EXP(E:RT)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

On Thu, 4/6/17, jmothilal <gjmothi...@gmail.com> 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&q

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

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

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

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 normal Text. also there look like another space in the cell but when i try to remove it backspace, last digit of number got

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

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

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

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

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

On Wed, 2/8/17, Paul Schreiner <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ Formula help needed To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> Date: Wednesday, February 8, 2017, 2:29 PM

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

$$Excel-Macros$$ Formula help needed

Dear Friends, I am stuck while preparing a dashboard. I need auto pickup of data based (in cell highlighted yellow) on model & date from the right side. If I change date (from 31-Jan-17 to 27-Jan-17) the data should change.. I think Index/Match with vlookup should work.. but not sure how to

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 < >

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

$$Excel-Macros$$ Formula Problem

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 do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel

$$Excel-Macros$$ Formula for Numbers Custom Format

Dear Experts, I have little knowledge about Numbers Custom Formatting (Manually) to attach Text with Numbers. I have to use these Numbers (with Text) in Chart. In a large Data being updated frequently, manually Numbers Custom Formatting will be quite hard and chance of error are sure. Kindly

$$Excel-Macros$$ formula that runs IF functions based upon changing identifiers

Hello I need some help: I have a spread sheet with dozens of thousands of unique identifies (Subscriber IDs). Each one represents a person. Some people were billed for a coverage periods and some people's billing for a coverage period was skipped. Now I have to figure out which people need

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

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)

$$Excel-Macros$$ formula proble

PLEASE SEE THE QUESTION IN THE FILE -- 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,

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 @

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

$$Excel-Macros$$ formula required

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 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,

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 > >

$$Excel-Macros$$ Formula for Conditional Formatting

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 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

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 >

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

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:

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*

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)

$$Excel-Macros$$ Formula required

Dear Sir please help me by resolving the issue. -- *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

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

gt; Date: Sat, Apr 16, 2016 at 11:53 AM > Subject: Fwd: $$Excel-Macros$$ Formula for Sum of nearest target value > To: excel-macros@googlegroups.com > > > Dear Experts, > Please advise if it is possible and I need your help in this regard. > > > Regards > Dheeraj >

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

-- Forwarded message -- From: Dheeraj Bankoti <dbank...@gmail.com> Date: Mon, Apr 18, 2016 at 7:22 AM Subject: Fwd: $$Excel-Macros$$ Formula for Sum of nearest target value To: excel-macros@googlegroups.com It seems now there is no excitement in group to help. Regards D

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

Dear Experts, Please advise if it is possible and I need your help in this regard. Regards Dheeraj -- Forwarded message -- From: Dheeraj Bankoti <dbank...@gmail.com> Date: Thu, Apr 14, 2016 at 11:24 AM Subject: $$Excel-Macros$$ Formula for Sum of nearest target value To:

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

Dear Experts, I am seeking formula for sum of nearest target value and its date in attached file. Kindly see the attached file. Regards Dheeraj -- 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 @

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

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

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 can extract the date from this cell text considering where the date can me change daily,

$$Excel-Macros$$ formula for creating numbers

Please see the attachment, is there any formula for creating column B and C, if the numbers goes on & on below in the column thanks in advance -- 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 @

$$Excel-Macros$$ Formula

hai this is sultan, actually I am creating some calculation for engineering company. kindly refer attached file and help someone. -- 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 @

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

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 the value 3] I have to caluculate same way in more raws for

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

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,

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]

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

$$Excel-Macros$$ FORMULA REQUIRED

As you may see I have already used different cell reference for summing up the UNIT and COST but I need a formula from which when I type and take the reference of all the cell i.e. A3:H3 under the heading of UNIT and same under the heading of COST, there must be a sum of the respective field in

Re: $$Excel-Macros$$ FORMULA REQUIRED

, As long as ever you can.” - John Wesley - From: Izhar <izharra...@gmail.com> To: excel-macros@googlegroups.com Sent: Friday, October 23, 2015 11:37 AM Subject: $$Excel-Macros$$ FORMULA REQUIRED As you may see I have already used differen

$$Excel-Macros$$ formula for compound interest

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* -- 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

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

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 shrinivas...@gmail.com wrote: Dear

$$Excel-Macros$$ Formula needed

Dear All Please find query. I have a excel sheet where I store all parts details I received . I want to make a list of all parts . I cant use remove duplicate function.. Can I get some other way/Formula so that list will keeps on updating as and when I will add new parts. Please find attached

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 abhishek@gmail.com 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

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

-Gtalk]* *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] *On Behalf Of *Rashid Khan *Sent:* 10 September 2012 1:20 *To:* excel-macros *Subject:* $$Excel-Macros$$ Formula to Calculate Slab Wise Commission as per Targets Achieved Hello All, We have a group

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

-Macros$$ Formula to Calculate Slab Wise Commission as per Targets Achieved Hello All, We have a group of employees having various Grades and Position. 1) A fixed target of sales to be achieved every month as shown in Col D (Target). 2) Each level has different Target Criteria

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

the attached* *Regards* *Rajan verma* *+91 7838100659 %2B91%207838100659 [IM-Gtalk]* *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] *On Behalf Of *Rashid Khan *Sent:* 10 September 2012 1:20 *To:* excel-macros *Subject:* $$Excel-Macros$$ Formula to Calculate Slab Wise

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

[IM-Gtalk]* *From:* excel-...@googlegroups.com javascript: [mailto: excel-...@googlegroups.com javascript:] *On Behalf Of *Rashid Khan *Sent:* 10 September 2012 1:20 *To:* excel-macros *Subject:* $$Excel-Macros$$ Formula to Calculate Slab Wise Commission as per Targets Achieved

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 so use

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 izharra...@gmail.com

$$Excel-Macros$$ FORMULA REQUIRED

I need figure in color column, the figure must be taken from column L to column R into the column G on the bases of article number, color and size. As an example I have put some figures in column G manually, these figures may be find in column L to R, I understand that the function we may use over

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

*Sent:* Tuesday, July 21, 2015 7:39 AM *Subject:* $$Excel-Macros$$ Formula to Display Latest PO number Using date and emp ID Dear Friends, I need help in creating the formula in attached file. In attached sheet. I have Sheet9 and Data Sheets. In Sheep 9, If I type the Emp ID in the cell

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

.” - John Wesley* - -- *From:* SridharBL sridhar@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tuesday, July 21, 2015 7:39 AM *Subject:* $$Excel-Macros$$ Formula to Display Latest PO number Using date and emp

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

Dear Friends, I need help in creating the formula in attached file. In attached sheet. I have Sheet9 and Data Sheets. In Sheep 9, If I type the Emp ID in the cell, its should look for data in Data sheet for the Emp ID and Latest Date for in column Period To and get the New PO number that

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

7:39 AM Subject: $$Excel-Macros$$ Formula to Display Latest PO number Using date and emp ID Dear Friends, I need help in creating the formula in attached file. In attached sheet. I have Sheet9 and  Data Sheets. In Sheep 9, If I type the Emp ID in the cell, its should look for data in Data

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 tigarman...@gmail.com

$$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. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

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 rajey...@gmail.com 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

$$Excel-Macros$$ formula required

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 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate

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

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

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

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 both the sheets

dear sir formula required in both the sheets as per mentioned in sheet 1. -- *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 @

Re: $$Excel-Macros$$ formula required

PFA... On Fri, Apr 3, 2015 at 12:06 PM, Rajesh Agarwal rajey...@gmail.com 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

$$Excel-Macros$$ formula required

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 @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread

Re: $$Excel-Macros$$ Formula required

Check this... On Tue, Mar 31, 2015 at 12:43 PM, Dhaval Shah todhavals...@gmail.com wrote: PFA Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ Formula required

PFA Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com 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 page of this forum @ https://www.facebook.com/discussexcel FORUM

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

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 15 SAR. Below than that there is a AED 15, KWD 15

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

-- From: rameshwari shyam rameshw...@gmail.com javascript: Date: Fri, Mar 13, 2015 at 10:08 AM Subject: Re: $$Excel-Macros$$ Formula based on some criteria To: excel-...@googlegroups.com javascript: Dear gaurav, required some more modification. if you can check AED in question sheet

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

Dear Team, Can any one help on this. Thanks, Rameshwari -- Forwarded message -- From: rameshwari shyam rameshwarish...@gmail.com 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

$$Excel-Macros$$ Formula Needed Please

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 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

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

please check the attachment On Fri, Mar 13, 2015 at 11:58 AM, Will Sob will00...@gmail.com 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

  1   2   3   4   5   6   7   >