thank u deepak its working
On Sat, Jul 27, 2013 at 12:09 AM, Deepak Barnwal barnwaldee...@gmail.comwrote:
PFA
Regards
deepak
On Fri, Jul 26, 2013 at 11:28 PM, vba v...@vabs.in wrote:
PFA
Actually years should be 37 not 36!!
HTH//Cheers
On Fri, Jul 26, 2013 at 10:12 AM, Shankar
Function eval(str As String)
word = Split(str, +)
For Each wrd In word
add_1 = WorksheetFunction.Sum(WorksheetFunction.Substitute(wrd, ', ))
add2 = add2 + add_1
Next
eval = add2
End Function
From: xlstime xlst...@gmail.com
To:
Hi Experts,
Do we have excel formula to calculate Fiscal Period from the date.
Ex:
[cid:image001.png@01CE8E07.35F27340]
Regards,
Krishnaraddi V Madolli.
CONFIDENTIALITY NOTICE: This message and any attachment are confidential and
may also be privileged. If you are not the intended recipient
what is fiscal period?
I heard it first time.
On Wed, Jul 31, 2013 at 4:01 PM, Krishnaraddi V. Madolli
krishnaraddi.mado...@asia.xchanging.com wrote:
Hi Experts,
** **
Do we have excel formula to calculate Fiscal Period from the date.
** **
Ex:
** **
** **
Hey
Pl refer..
HTH//Vabs
On Wed, Jul 31, 2013 at 4:01 PM, Krishnaraddi V. Madolli
krishnaraddi.mado...@asia.xchanging.com wrote:
Hi Experts,
** **
Do we have excel formula to calculate Fiscal Period from the date.
** **
Ex:
** **
** **
Regards,
find the formula
closing date Fiscal Period1-Jan-12 Q1-2012
=+IF(MONTH(B6)=3,Q1,IF(MONTH(B6)=6,Q2,IF(MONTH(B6)=9,Q3,IF(MONTH(B6)=12,Q4,-YEAR(B6)
2-May-12 Q2-20125-Sep-12 Q3-20126-Oct-12 Q4-2012
1-Jan-13 Q1-2013
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
Thanks.
Regards,
Krishnaraddi V Madolli.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Gaurav Garg
Sent: 31 July 2013 16:13
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Fiscal Period calculation
find the formula
closing date
Fiscal
Use below formula or attached file
=QIF(MONTH(A2)4,1,IF(MONTH(A2)7,2,IF(MONTH(A2)10,3,4)))-YEAR(A2)
From: Krishnaraddi V. Madolli krishnaraddi.mado...@asia.xchanging.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Wednesday, July 31,
From: ravinder negi ravi_colw...@yahoo.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Wednesday, July 31, 2013 4:12 PM
Subject: Re: $$Excel-Macros$$ Move Data to Different Sheets based on CFA Names
PFA...
NOTE:- Please remove
thank you so much vijay.
these are enough for me.
thanks again.
Regards,
Waseem Saifi
On Wed, Jul 31, 2013 at 4:53 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote:
Respected Waseem,
Please find the attached files.All games are not possibly sent by mail
because gmail cannot handle more than 8
Dear Krishna,
Try it
*=QINT((MONTH($A2)-1)/3)+1-TEXT($A2,)*
or
*=LOOKUP(MONTH(A2),{1,4,7,10},{Q1,Q2,Q3,Q4})-TEXT($A2,)*
see attachment for more clarity.
On Wed, Jul 31, 2013 at 4:01 PM, Krishnaraddi V. Madolli
krishnaraddi.mado...@asia.xchanging.com wrote:
Hi Experts,
Thanks Noorain bai.
Regards,
Krishnaraddi V Madolli.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of NOORAIN ANSARI
Sent: 31 July 2013 17:49
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Fiscal Period calculation
Dear Krishna,
Try it
It's Not. Thanks.
-- Forwarded message --
From: Basole ricardo...@gmail.com
Date: Wed, Jul 24, 2013 at 8:44 PM
Subject: $$Excel-Macros$$ Re: Translate PDF as a text
To: excel-macros@googlegroups.com
Hi, see (attached) if that's what you want
Em quarta-feira, 24 de julho de
I have a lot of work for dashboards and excel charting based vBA
Can pay weekly or by task in hours. If any one who is an expert in VBA is
interested, Pla email me only. We can talk abt tasks, hours in commitment,
pay etc
Thanks
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
Thanks, i changed your code little bit and it worked
Sub create_conditional_formatting()
Range(b1).Select
With Sheet1
With .Range(B1:E5)
'.FormatConditions.Add xlExpression, Formula1:= _
'=COUNTIF($A$1:$A$5,B1)=0
.FormatConditions.Add xlExpression, Formula1:= _
Dear All,
I have a very particular question. Is there a way to prevent opening a
macro enabled excel spreadsheet being opened in OpenOffice products?
One method suggested on some other forum was to check if the file is opened
by excel application or other. If it is not excel then close it.
1)
I have a range of data that has 5 columns P:T, (Asset No, Part No, Lot No,
Date/time stamp and User ID) and up to 3000 rows, for now. I have Command
Button with code that works fine for retrieving all rows that have a
specified asset numbers (Input cell C5).
I just want to include Buttons
Hi,
I want you to see this,Just click herehttp://chelseafletcher.com/montana/
and sign in to view. The file is too large so I couldn't attach it
Kind regards
--
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
I have a complex program I wrote in Excel 2003 about six years ago, and I
am working to update it. In the program, I am concerned about the sum of
data entered into two columns and totaled in the third column. There are
about 60 groupings of cells, all independent, with about 25 sets of cells
Hi Tom,
please change the line
If c.Value = sAsset Then
to
If c.Value = sAsset and c.Offset(0,1).Value = ws2.Range(E5) And
c.Offset(0,2).Value=ws2.Range(G5) Then
If it doesn't work then share your file...
On Thu, Aug 1, 2013 at 4:36 AM, Tom Board tomb...@gmail.com wrote:
I have a range of
I am not sure about this becuse Microsoft excel vba doesn't work in
Openoffice and if you really want to prevent your code then go for COM
addin Using VSTO.
On Wednesday, 31 July 2013 23:58:25 UTC+5:30, Aashish Watve wrote:
Dear All,
I have a very particular question. Is there a way to
Dear Experts,
I want to sum of values basis on two conditions.
it is explained in attachment.
I also tried offset function, but it didn't work properly.
please help.
Regards,
Waseem Saifi
--
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
you can use
=SUM(INDIRECT(CELL(address,INDIRECT(r7cMATCH(B2,F6:M6,0)+5,FALSE)):CELL(address,INDIRECT(rMATCH(B3,E7:E10,0)+6cMATCH(B2,F6:M6,0)+5,FALSE
From: Waseem Saifi waseemsa...@gmail.com
To: excel-macros excel-macros@googlegroups.com
Sent: Thursday,
23 matches
Mail list logo