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