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
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 wrote:
> ??
> That's what
??
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 yo
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
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 find
try the attached file
On Fri, Jul 22, 2011 at 2:33 AM, Vikas Chouhan 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 wrote:
>
>> Hi Friends,
>>
>> In the attached sheet wherever we
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 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 which doe
Hello Prabhu,
Use this in B2 & copy down.
=IF(ISNUMBER(SEARCH("Opt. ",A2)),LOOKUP(2,1/ISERROR(SEARCH("Opt.
",A$2:A2)),A$2:A2)&SUBSTITUTE(A2,"Opt. ","#"),A2)
Then copy Col_B *Paste Values *in Col_A. Then after delete Col_B.
HTH
Haseeb
--
--
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é :
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$$ Exc
Thank you for your solution.
On Wed, Apr 13, 2011 at 10:19 AM, STDEV(i) wrote:
> 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 wrote:
>
>> Hi,
>> I need a formula adding each month one column.
>> Attached f
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 wrote:
> Hi,
> I need a formula adding each month one column.
> Attached file has a details.
>
> Regards,
> Vin
>
--
--
As Your formula is circular , it will cause error
Go to Excel Options>Formula>Iterations>Check the box on
restart excel
Error will not get there
On Fri, Feb 18, 2011 at 8:33 PM, vitorjose wrote:
> I prepare construction estimates and am required in some cases to add
> costs for providing a pe
27 matches
Mail list logo