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

Re: $$Excel-Macros$$ Formula Help

Thanks to all for the Prompt reply. The problem is solved. Regards Hemant Dange On Dec 7, 9:55 pm, "dguillett1" wrote: > A macro to populate column B > > Don Guillett > SalesAid Software > dguille...@gmail.com > > > > -Original Message- > From: hemant > Sent: Wednesday, December 07, 201

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

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