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

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

?? That's what sorting does.   evidently, you have additional requirements that you've not included. 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

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

Dear Shrinivas, Try using Select Visible Cells in customizng Quick Access Toolbar (QAB) activate it select multipul cells and click on Select Visible Cells button and then copy and past. Please revert if it don't work. On Tue, Apr 29, 2014 at 4:51 PM, Paul Schreiner

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

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

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

Hi, You can’t do it with a formula (a formula only changes the value of the cell which contains it). Either you use the replace command (Ctrl+H) or you have to use a macro. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Prabhu Envoyé

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

Hi, In L8 : =SUM(OFFSET($D8MONTH(TODAY( If you are to use todays month. Cheers. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de vinod rao Envoyé : mardi 12 avril 2011 19:24 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$

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

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

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