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

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

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

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

$$Excel-Macros$$ Formula Help !

​​ 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 in 2015, and the ones which have not been taken care off needs to begin on 15th Jan 2015 if you look at the column, some dates are in 2014 some dates are before 2014 som

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

$$Excel-Macros$$ Formula help

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

Hey! Look at the file, Good luck! 2012/3/7 Avinash > hi all can anyone help me to get the desired result in this sheet > > i have attached the sheet please see the attachment for better > understanding. > > Regards > > Avinash > > -- > FORUM RULES (986+ members already BANNED for violation) >

Re: $$Excel-Macros$$ formula help

quot;=VLOOKUP(G2,A:B,2,0)&""--""&COUNTIF(A:A,G2)" End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: NOORAIN ANSARI Sent: Wednesday, March 07, 2012 10:20 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros

Re: $$Excel-Macros$$ formula help

Dear Avinash, Please use it.. =B2&"--"&COUNTIF($A$2:A2,A2) or =$B2&"--"&SUMPRODUCT(--($A$2:$A2=$A2)) See attached sheet. -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*

$$Excel-Macros$$ formula help

hi all can anyone help me to get the desired result in this sheet i have attached the sheet please see the attachment for better understanding. Regards Avinash -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please H

Re: $$Excel-Macros$$ Formula Help

m: hemant > Sent: Wednesday, December 07, 2011 2:30 AM > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ Formula Help > > Hi all > > I need help on the following in EXCEL 2007: > > Compare the values of sheet 1:column A with Values of Sheet2:column A > > If

Re: $$Excel-Macros$$ Formula Help

A macro to populate column B Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: hemant Sent: Wednesday, December 07, 2011 2:30 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Formula Help Hi all I need help on the following in EXCEL 2007: Compare

Re: $$Excel-Macros$$ Formula Help

hi please see the attached File.. Hope this will help Rajan. On Wed, Dec 7, 2011 at 2:00 PM, hemant wrote: > Hi all > > I need help on the following in EXCEL 2007: > > Compare the values of sheet 1:column A with Values of Sheet2:column A > > If the CELL values in sheet1 column matches with Rang

Re: $$Excel-Macros$$ Formula Help

Dear Hemant, You can use below function with Conditonal Formating.. =MATCH($A1,Sheet2_range,0) Sheet2_range is name range of Sheet2 B Column. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ Formula Help

Dear Hemant, It can be achieved using the vlookup formula. Suppose you have a data set in Sheet 1 from A1 to A9, which you need to compare with the values present in column A in Sheet 2 Then in Column B, please type: =VLOOKUP(A1,Sheet1!$A$1:$A$9,1,0) and drag the formula down. You will get some

$$Excel-Macros$$ Formula Help

Hi all I need help on the following in EXCEL 2007: Compare the values of sheet 1:column A with Values of Sheet2:column A If the CELL values in sheet1 column matches with Range of values in Sheet2 column. copy that CELL VALUE from sheet1 and paste it adjacent column (Column B) of sheet2. Or COLO

Re: $$Excel-Macros$$ Formula Help Required Urgent

Dear Andy, Thank u On Fri, Jun 4, 2010 at 3:55 PM, Aindril De wrote: > Hi Venkat, > > This can be achieved using array formulas in Excel. > Suggest you to look into the discussion in the attached link that should > resolve your issue: > http://www.mrexcel.com/forum/showthread.php?t=312142 >

Re: $$Excel-Macros$$ Formula Help Required Urgent

Hi Venkat, This can be achieved using array formulas in Excel. Suggest you to look into the discussion in the attached link that should resolve your issue: http://www.mrexcel.com/forum/showthread.php?t=312142 Regards, Andy On Thu, Jun 3, 2010 at 6:57 PM, Venkatesan c wrote: > Dear Group, > >

$$Excel-Macros$$ Formula Help Required Urgent

Dear Group, Can i have UNIQUEIFS Function its some thing like SUMIFS Best Regards, * Venkat * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/e

$$Excel-Macros$$ formula help

Can you help me please? I have a bit of a situation and I need some fresh eyes and brain power. I am trying to set up a spreadsheet for my dad in excel and I have run into a formula snag. This is the last formula I need to complete this worksheet and I need to get it right. My brain hurts from tr