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
ou
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>*From:* Shrinivas Shevde
> *To:* excel-macros@googlegroups.com
> *Sent:* Tuesday, April 29, 2014 6
the people you can,
As long as ever you can.” - John Wesley
-
>
> From: Shrinivas Shevde
>To: excel-macros@googlegroups.com
>Sent: Tuesday, April 29, 2014 6:41 AM
>Subject: $$Excel-Macros$$ Excel formula help
Please find attacehd Sheet
--
Shrini
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, l
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
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
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
--
--
: 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."or
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"
$$ 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
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
>
--
--
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 :
http://twitter.com/excelda
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
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 bo
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 ordered.
34 matches
Mail list logo
