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

hi Kaushik use this one =IF(C3>=VLOOKUP(D3,$F$13:$G$16,2,0),"yes","no") excel sheet is attached for your reference *With Regards:* *CMA** Ankur Pandey* *B.Com (H), C.M.A * * Mob: :- +919532513513* *P* Please don't print this e-mail unless you really need it. "This e-mail message

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

​hope this attached fulfill your requirement.​ *Regards,* *For quick responds click here for Message * On Sun, May 13, 2018 at 6:16 AM, KAUSHIK SAVLA wrote: > Hi All, > > Attached is the excel file which I am referring for help. > >

$$Excel-Macros$$ Excel Formula - Help needed

Hi All, Attached is the excel file which I am referring for help. Background: Daily basis there are some transactions getting created and are either approved or pending or rejected. For the one's which are pending we want to build a tracker which once data is dumped it will show whether

Re: $$Excel-Macros$$ Excel formula help need

you can, As long as ever you can.” - John Wesley - From: Shrinivas Shevde shrinivas...@gmail.com To: excel-macros@googlegroups.com Sent: Tuesday, April 29, 2014 6:41 AM Subject: $$Excel-Macros$$ Excel formula help need

Re: $$Excel-Macros$$ Excel formula help need

the people you can,As long as ever you can.” - John Wesley* - *From:* Shrinivas Shevde shrinivas...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tuesday, April 29, 2014 6:41 AM *Subject:* $$Excel-Macros$$ Excel formula help need Please

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

, 23 Mar 2012 21:50:49 To: excel-macros@googlegroups.com Cc: resp...@gmail.com Subject: Re: $$Excel-Macros$$ Excel formula help needed Hi In B3 on Sheet1 =IFERROR(MATCH('PL (2)'!$H$4,INDIRECT('INDEX(ShtName,ShtSelected)'!A4:i4),0),2) Define B3 '*MatchCol'* * * Now in B12 and copy down across

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

. Sent from my BlackBerry® smartphone from Airtel Ghana -- *From: * Kris krishnak...@gmail.com *Date: *Fri, 23 Mar 2012 21:50:49 -0700 (PDT) *To: *excel-macros@googlegroups.com​ *Cc: *resp...@gmail.com *Subject: *Re: $$Excel-Macros$$ Excel formula help needed Hi

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

...@gmail.com Date: Sat, 24 Mar 2012 00:56:33 To: excel-macros@googlegroups.com Cc: Kriskrishnak...@gmail.com; resp...@gmail.com Subject: Re: $$Excel-Macros$$ Excel formula help needed PFA Kris On Saturday, 24 March 2012 12:51:10 UTC+5:30, Kris wrote: It does. Set your calculation to automatic

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

OK Replace the B3 formula on sheet1 with =IF('PL (2)'!$H$4=ALL Year,2,MATCH('PL (2)'!$H$4,INDIRECT('INDEX(ShtName,ShtSelected)'!A4:i4),0)) and in b12 and copy down across

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

Hi Maries The formula works perfectly for SIC, however for GCB and GGBL, it seems to pick the same figures for all the years. with FML , its picking the an incorrect figures. kindly verify for me. thanks On Thu, Mar 22, 2012 at 8:30 PM, Maries talk2mar...@gmail.com wrote: GCB GGBL Error

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

Hi on Sheet1 In D2:D5 FML SIC GCB GGBL and define the range *'ShtName*' Define B2 '*SheetSelected*' In A12 and copied down across on PL(2) =IF(COLUMNS($A12:A12)=$H$6+1,INDEX(INDIRECT('INDEX(ShtName,ShtSelected)'!A5:i120),ROWS(A$12:A12),COLUMNS($A12:A12)),) Kris -- FORUM RULES

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

Kris, this solution is spot on. thanks working to perfection On Fri, Mar 23, 2012 at 3:33 PM, Kris krishnak...@gmail.com wrote: Hi on Sheet1 In D2:D5 FML SIC GCB GGBL and define the range *'ShtName*' Define B2 '*SheetSelected*' In A12 and copied down across on PL(2)

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

i think i get excited over the first few trials but i just realised a few bug .the figures doesnt match the years when you for instance select a year to view On Fri, Mar 23, 2012 at 3:41 PM, hilary lomotey resp...@gmail.com wrote: Kris, this solution is spot on. thanks working to perfection

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

OK. In B12 and copied down across, =IF(COLUMNS($A12:B12)=$H$6+1,INDEX(INDIRECT('INDEX(ShtName,ShtSelected)'!A5:i120),ROWS(B$12:B12),MATCH($H$4,INDIRECT('INDEX(ShtName,ShtSelected)'!A4:i4),0)+COLUMNS($B12:B12)-1),) Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use

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

@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel formula help needed OK. In B12 and copied down across, =IF(COLUMNS($A12:B12)=$H$6+1,INDEX(INDIRECT('INDEX(ShtName,ShtSelected)'!A5:i120),ROWS(B$12:B12),MATCH($H$4,INDIRECT('INDEX(ShtName,ShtSelected)'!A4

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

Hi In B3 on Sheet1 =IFERROR(MATCH('PL (2)'!$H$4,INDIRECT('INDEX(ShtName,ShtSelected)'!A4:i4),0),2) Define B3 '*MatchCol'* * * Now in B12 and copy down across, =IF(COLUMNS($A12:B12)=$H$6+1,INDEX(INDIRECT('INDEX(ShtName,ShtSelected)'!A5:i120),ROWS(B$12:B12),MatchCol+COLUMNS($B12:B12)-1),)

$$Excel-Macros$$ Excel formula help needed

Hi Oxford Excel Gurus In the fill attached sheet PL i have been able to write a formula that can show how many number of years i want to view the report ie if i want to see 5 years report i will select from the drop down, and so forth. and the number o years specified will show In the 2nd sheet

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

HI, PFA. Regards, MARIES. On Thu, Mar 22, 2012 at 4:40 PM, hilary lomotey resp...@gmail.com wrote: Hi Oxford Excel Gurus In the fill attached sheet PL i have been able to write a formula that can show how many number of years i want to view the report ie if i want to see 5 years report i

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

genius Maries Great solution. works to perfection. thanks boss On Thu, Mar 22, 2012 at 3:56 PM, Maries talk2mar...@gmail.com wrote: HI, Please find the attached file of Revised one. Ignore Previous one. Regards, MARIES. On Thu, Mar 22, 2012 at 7:07 PM, Maries talk2mar...@gmail.com

RE: $$Excel-Macros$$ Excel formula help

See the attached File, From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhu Sent: Thursday, July 21, 2011 10:54 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel formula help Hi Friends, In the attached sheet wherever we

$$Excel-Macros$$ Excel formula help

Hi Friends, In the attached sheet wherever we find *Opt. *(Opt dart and a space) is replace with # and add with the previous cell which does not contain Opt.originally. As per the attached sheet A9,10,11,12 we have to remove Opt. and add # with A8 as prefix. Similarly in A3 Opt. 0D1-

RE: $$Excel-Macros$$ Excel formula help

: jeudi 21 juillet 2011 19:24 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Excel formula help Hi Friends, In the attached sheet wherever we find Opt. (Opt dart and a space) is replace with # and add with the previous cell which does not contain Opt.originally. As per

Re: $$Excel-Macros$$ Excel formula help

try this =IF(ISERROR(REPLACE(A2,FIND(Opt.,A2),3,#)),A2,(REPLACE(A2,FIND(Opt.,A2),3,#))) On Thu, Jul 21, 2011 at 10:54 PM, Prabhu prabhugate...@gmail.com wrote: Hi Friends, In the attached sheet wherever we find *Opt. *(Opt dart and a space) is replace with # and add with the previous cell

Re: $$Excel-Macros$$ Excel formula help

try the attached file On Fri, Jul 22, 2011 at 2:33 AM, Vikas Chouhan vikask...@gmail.com wrote: try this =IF(ISERROR(REPLACE(A2,FIND(Opt.,A2),3,#)),A2,(REPLACE(A2,FIND(Opt.,A2),3,#))) On Thu, Jul 21, 2011 at 10:54 PM, Prabhu prabhugate...@gmail.com wrote: Hi Friends, In the

RE: $$Excel-Macros$$ Excel formula help

$$ Excel formula help Hi, I need a formula adding each month one column. Attached file has a details. Regards, Vin -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

Re: $$Excel-Macros$$ Excel formula help

Thank you for your solution. On Wed, Apr 13, 2011 at 10:19 AM, STDEV(i) setiyowati.d...@gmail.comwrote: try this formula and see if it helps =SUM(OFFSET($D8:$I8,0,0,1,MONTH(TODAY( On Wed, Apr 13, 2011 at 12:23 AM, vinod rao vinod.ma...@gmail.com wrote: Hi, I need a formula adding

$$Excel-Macros$$ Excel formula help

Hi, I need a formula adding each month one column. Attached file has a details. Regards, Vin -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ Excel formula help

try this formula and see if it helps =SUM(OFFSET($D8:$I8,0,0,1,MONTH(TODAY( On Wed, Apr 13, 2011 at 12:23 AM, vinod rao vinod.ma...@gmail.com wrote: Hi, I need a formula adding each month one column. Attached file has a details. Regards, Vin --

$$Excel-Macros$$ Excel Formula Help

I prepare construction estimates and am required in some cases to add costs for providing a performance bond. I arrive at a total price lets say $1,000,000 then add in bond cost at $10 per thousand (10,000). If am successful i receive a contract for 1,010,000 from my customer. When i go to my

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

As Your formula is circular , it will cause error Go to Excel OptionsFormulaIterationsCheck the box on restart excel Error will not get there On Fri, Feb 18, 2011 at 8:33 PM, vitorjose victor_pa...@cox.net wrote: I prepare construction estimates and am required in some cases to add costs

$$Excel-Macros$$ Excel Formula Help

Hi there, I was wondering if there is any body who could help me with a formula that i am having great difficulty with. Platform: I have one spreadsheet open with three worksheets that are used. 1= phead - Contains Purchase order numbers and dates of the order but no information what was