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
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.
>
>
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
you can,
As long as ever you can.” - John Wesley
-
From: Shrinivas Shevde shrinivas...@gmail.com
To: excel-macros@googlegroups.com
Sent: Tuesday, April 29, 2014 6:41 AM
Subject: $$Excel-Macros$$ Excel formula help need
the people
you can,As long as ever you can.” - John Wesley*
-
*From:* Shrinivas Shevde shrinivas...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Tuesday, April 29, 2014 6:41 AM
*Subject:* $$Excel-Macros$$ Excel formula help need
Please
, 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
.
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
...@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
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
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
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
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)
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
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
@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
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),)
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
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
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
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
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-
: 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.originally.
As per
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
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
$$ 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) 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
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 :
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
--
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
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
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
31 matches
Mail list logo