Great noorain babu..!!
Regards,
@Suman
Send on the move with Galexy y.
On Jun 23, 2012 12:09 AM, "NOORAIN ANSARI" wrote:
> Dear Mothilal,
>
> If you don't want in Text Format Please use
>
> =DATEDIF(D2,E2,"d") select formula cell, press ctrl+1 and type in
> custom yy mm dd
>
> See attached sheet
Hi Rajan
no counts are calculated, Input table 2 is manual feeded table. In result
table I want TOTAL of values in column G and/or H against each "BL#_MAWB#"
against each "Invoice#".
Regards
Amit
On Fri, Jun 22, 2012 at 6:09 PM, Rajan_Verma wrote:
> One instant question:
>
> ** **
>
> How
Try this
Sub Get_Vessel_Schedule()
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim strSql As String
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
cn.Open ( _
"User ID=User" & _
";Password=Pass" & _
";Data Source=My DB" & _
Hello,
Super new to thsi world but trying to put something together that will
execute a simple SQL statement against on of our Oracle Databases and
return the results. The Code for the Macro is below but I am getting "Data
Type is not Supported". Anyone help with that. Also, another questio
Dear Mothilal,
If you don't want in Text Format Please use
=DATEDIF(D2,E2,"d") select formula cell, press ctrl+1 and type in
custom yy mm dd
See attached sheet
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Fri, Jun 22, 2012 at 12:55 PM, jmothilal
Dear Kalyan,
Please use..
*=VLOOKUP("*"&MID(B25,7,2)&"*"&C25,$B$2:$C$21,2,0)*
or
*=INDEX($C$2:$C$21,MATCH("*"&MID(B25,7,2)&"*"&C25,B2:B21,0))*
or
*=LOOKUP(2,1/((RIGHT(B2:B21,7)="CE "&C25)),C2:C21)*
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.co
Excelent Rajan fine solution
Chilexcel
2012/6/22 Suman :
> Tkanks Rajan ji
>
> Regards,
> @Suman
> Send on the move with Galexy y.
>
> On Jun 22, 2012 5:58 PM, "Rajan_Verma" wrote:
>>
>> Here are two vba solution for that :
>>
>> 1).
>>
>> Function DOB(rng As Range)
>> DOB = VBA.F
2012/6/22 ChilExcel
> /\ \ __ /\_ \
> /\_ \
> ___ \ \ \___ /\_\\//\ \ __ __ ____
> __\//\ \
> /'___\\ \ _ `\\/\ \ \ \ \/'__`\/\ \/'\ /'___\
> /'__`\\ \ \
>/\ \__/ \ \ \ \ \\ \ \ \_\ \_ /\ __/\/>
Tkanks Rajan ji
Regards,
@Suman
Send on the move with Galexy y.
On Jun 22, 2012 5:58 PM, "Rajan_Verma" wrote:
> Here are two vba solution for that :
>
> 1).
>
> Function DOB(rng As Range)
> DOB = VBA.Format(VBA.DateDiff("d", rng, Date), "yy mm dd")
> End Function
>
> 2).
>
> Function DatedDiff(
yes, this is the problem, we want to different content each time, what is
on that specific rows
On Fri, Jun 22, 2012 at 5:52 PM, Rajan_Verma wrote:
> No option in excel to repeat row in bottom,
>
> You can use image of in centre footer.
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
One instant question:
How is counts Calculated in Input table 2?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Amit Gandhi
Sent: 22 June 2012 5:20
To: excel-macros@googlegroups.com
Subject: $$Ex
Use this :
=SUMPRODUCT(--(RIGHT(B2:B21,7)="CE "&C25),C2:C21)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kal xcel
Sent: 22 June 2012 4:27
To: excel-macros@googlegroups.com
Subject: $$Excel-Mac
Here are two vba solution for that :
1).
Function DOB(rng As Range)
DOB = VBA.Format(VBA.DateDiff("d", rng, Date), "yy mm dd")
End Function
2).
Function DatedDiff(dtStart As Date, dtEnd As Date) As String
Dim ArrStart
Dim ArrEnd
Dim ArrResult
ArrStart = Array(Year(dtSt
No option in excel to repeat row in bottom,
You can use image of in centre footer.
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Divaker Pandey
Sent: 22 June 2012 3:43
To: excel-macros@googlegroups
Hi Experts
I have two Input/Lookup tables, and 1 result table. I want a formula which
can give me desired result instantly. Sample file is attached for your
ready reference.
How it will be possible? Pls help me here.
Regards
Amit
--
--
FORUM RULES (986+ members already BANNED for violation)
Dear Experts,
Please help me to solve my query. Details is in attached sheet.
--
*Kalyan Chattopadhyay*
*Executive Sales Coordinator*
*R. S. H. Pvt. Ltd.*
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please He
try this
=+DATEDIF(A1,NOW(),"y")&" Years, "&DATEDIF(A1,NOW(),"ym")&" Months,
"&DATEDIF(A1,NOW(),"md")&" Days "
Regds
On Fri, Jun 22, 2012 at 1:29 PM, Suman wrote:
> Hi Dear !
> Please use this formula if its help you.
> =Text(Today()-that cell which contain ur birth date,"yy")
>
> Regards,
> @S
Hello Krishna
I cannot open the file.
Can you please check your file?
Thanks
Rashid Khan
On Thursday, June 21, 2012 6:57:23 PM UTC+4, Krishnaraddi wrote:
> Hi All
>
> Please find the attached PPT consists of few useful excel functions
> explained. I have prepared this document for training purpo
1. In PageSetup we have rows repeat at top, there should repeat at bottom
as well.
Divaker
9582060233
On Thu, Jun 21, 2012 at 8:58 PM, Maries wrote:
> *My Suggestion*
>
>
> http://www.google.com/moderator/#15/e=455db&t=455db.40&f=455db.66a716&q=455db.66a716
>
>
>
>
> On Tue, Jun 19, 2012 a
First of all sorry for the off-topic.
Maries can you answer/help me with the querry that i have sent you trough
email ?
Thanks
On Thursday, June 21, 2012 10:46:50 AM UTC+3, Maries wrote:
> Hi,
>
> Find the attached file of Construction Projects Dashboard which is
> designed by me.
>
>
>
Hi Dear !
Please use this formula if its help you.
=Text(Today()-that cell which contain ur birth date,"yy")
Regards,
@Suman
Send on the move with Galexy y.
On Jun 22, 2012 12:56 PM, "jmothilal" wrote:
>
> Dear any one
>
> i want find age month days calculations in between two days. pls help me
Thanks
On Fri, Jun 22, 2012 at 1:04 PM, Excel Vba wrote:
> Hi J. Mothilal**,
>
> Try datedif funtions.
>
> =datedif(A1,B1,"Y") for years
> =datedif(A1,B1,"ym") for months
> =datedif(A1,B1,"md") for days
>
> whereas in cell A1, type oldest date or date from which you want to
> calculate,
> and in
Hi J. Mothilal**,
Try datedif funtions.
=datedif(A1,B1,"Y") for years
=datedif(A1,B1,"ym") for months
=datedif(A1,B1,"md") for days
whereas in cell A1, type oldest date or date from which you want to
calculate,
and in cell B1, type the newest date or date till which you want to
calculate.
On F
Dear any one
i want find age month days calculations in between two days. pls help me
thanks with
--
*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titl
24 matches
Mail list logo
