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 may
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.
>
> Background: Daily basis there are some transactions getting
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
follow
OK
Replace the B3 formula on sheet1 with
=IF('P&L (2)'!$H$4="ALL Year",2,MATCH('P&L
(2)'!$H$4,INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A4:i4"),0))
and in b12 and copy down & across
=IF(ISNUMBER(MatchCol),IF(COLUMNS($A12:B12)<=$H$6+1,INDEX(INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A5:i120"),
Mar 2012 00:56:33
To:
Cc: Kris;
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.
>
> Kris
>
> On Saturday, 24 March 2012 12:43:42 UTC+5:30, hi
n you select another year.
> Sent from my BlackBerry® smartphone from Airtel Ghana
> --
> *From: * Kris
> *Date: *Fri, 23 Mar 2012 21:50:49 -0700 (PDT)
> *To: *
> *Cc: *
> *Subject: *Re: $$Excel-Macros$$ Excel formula help needed
>
> Hi
>
>
21:50:49
To:
Cc:
Subject: Re: $$Excel-Macros$$ Excel formula help needed
Hi
In B3 on Sheet1
=IFERROR(MATCH('P&L
(2)'!$H$4,INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A4:i4"),0),2)
Define B3 '*MatchCol'*
*
*
Now in B12 and copy dow
Hi
In B3 on Sheet1
=IFERROR(MATCH('P&L
(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:
@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(S
Thanks Kris its working great. 100% THIS time around
Maries thanks a zillion too your formula is also working 100%
i just realised that you made cell B11 an absolute reference, i just
changed it to B$11 and its now working 100%.
thanks both for you assistance
=IFERROR(CHOOSE(index,INDIRECT("AL
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 violati
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 wrote:
> Kris, this solution is spot on. thanks working to perfection
>
>
> On Fri, Mar
Kris, this solution is spot on. thanks working to perfection
On Fri, Mar 23, 2012 at 3:33 PM, Kris 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 P&L(2)
>
>
> =IF(COLUMNS($
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 P&L(2)
=IF(COLUMNS($A12:A12)<=$H$6+1,INDEX(INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A5:i120"),ROWS(A$12:A12),COLUMNS($A12:A12)),"")
Kris
>
>
--
FO
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 wrote:
> GCB & GGBL Error Rectified. PFA latest.
>
genius Maries
Great solution. works to perfection. thanks boss
On Thu, Mar 22, 2012 at 3:56 PM, Maries 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 wrote:
>
>> Hi,
>>
>> PFA.
>>
>> =I
HI,
PFA.
Regards,
MARIES.
On Thu, Mar 22, 2012 at 4:40 PM, hilary lomotey wrote:
> Hi Oxford Excel Gurus
>
> In the fill attached sheet "P&L" 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 sele
Hi Oxford Excel Gurus
In the fill attached sheet "P&L" 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 shee
18 matches
Mail list logo
