review the attached file for simple approach
On Wed, Sep 25, 2013 at 4:15 PM, Ravi Kumar wrote:
> Hi,
>
> ** **
>
> Another way… See the attached file.
>
> ** **
>
> ** **
>
> =DATE(YEAR(D5),MONTH(D5),DAY(D5)+15)
>
> ** **
>
> ** **
>
> * *
>
> *Warm Regards,*
>
> *Ravi Kumar.*
>
> *
Dear Junaid,
Kindly attach the error file .
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Sep 25, 2013 at 12:26 PM, Junaid wrote:
> Hi guys,
>
> I am working on Excel 2007 macros. My requirement is to access MS SQL s
recheck your connection string
and where you are getting this error
On 25 Sep 2013 12:26, "Junaid" wrote:
> Hi guys,
>
> I am working on Excel 2007 macros. My requirement is to access MS SQL
> server DB from excel, using VBA. I am just trying to pull some data by
> connecting to DB, but facing th
Hi,
This is Aamir Shahzad from Pakistan, working in Bank as MIS officer, work
in excel and learning of advance excel formulas by books & this forum. I
intended to learn Macros after expert in formulas.
what streamline should I follow? any idea?
On Thu, Sep 26, 2013 at 1:02 AM, Vassili Papadopoul
Hello,
Vassili here, I live in Michigan working for an automotive supplier and I
really enjoy working with excel. I sometimes get some assignments that are
above my capabilities so any assistance is greatly appreciated.
Thanks!
Vassili
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And d
Hello
I am stuck with an assignment that I have spent a lot of time trying to
come up with a conventional solution and I am at a point where I need
advise from the esteemed sages on this forum.
Output File name: "NAOPIP Review" with multiple line items (~2k).
Instructions: The tab has
Visit here
http://excelpoweruser.wordpress.com/2011/08/09/get-unique-list-another-method/
For more method to get unique see this
http://excelpoweruser.wordpress.com/?s=Unique+list
On Wed, Sep 25, 2013 at 8:32 AM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hello,
>
> Am trying t
Hello,
Am trying to extract unique values using array but am not getting correct
count. I have attached the excel in Sheet1 there is main data, in sheet2 am
getting values after running macros and in sheet3 colored cells is the
orginal value and in Column C I have put countif formula which is not
Hi,
I'm trying to copy the data from the website and below is my code I'm
getting Dim clip As DataObject saying User defined type not defined. and
please verify the code whether its correct. My table id is table1.
[code]
Sub GetTable()
dataarr = Range("A2:A4") 'C
Hi,
Another way. See the attached file.
=DATE(YEAR(D5),MONTH(D5),DAY(D5)+15)
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ravinder
Sent: Wednesday, September 25, 2013 4:31 PM
To: excel-macros@googlegroups
PFA
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of sridher sharma
Sent: Wednesday, September 25, 2013 3:58 PM
To: excel-macros
Subject: $$Excel-Macros$$ for due date
i m taken a loan from bank witch have due date 16 day after 1st date (
29/04/2013 is
Thanks Mr. ravinder,
But I dont think it is that simple.You have provided the correct formula.
ButI have to calculate the euclidean distance for each sample against all
samples(e.g sample 1 with all other samples, sample 2 with all other
samples, etc)
So there will be huge no. of calculation
i m taken a loan from bank witch have due date 16 day after 1st date (
29/04/2013 is 1st day and due date is 14/05/2013) how to fined next due
DATE
NEED FORMULA
THANX
Regards
Sridher Sharma
--
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
Give us more information..for this.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sandes Bagwe
Sent: Tuesday, September 24, 2013 8:56 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ I need help on one Macro creation
Hello All,
I h
Dear Friends,
I got the solution.
Thanks Aamir for giving your idea
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Sep 25, 2013 at 1:02 PM, Aamir Shahzad wrote:
> you can use this formula
>
> =TEXT(A12,"h
Thanks Ravinder for your kind help. I have not checked it yet, but if I
face any issue, definitely I'll get back to you for further assistance,
hope you would't mind. :)
Thanks & Regards,
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are confidential
and inten
you can use this formula
=TEXT(A12,"hhmm")
On Wed, Sep 25, 2013 at 12:13 PM, अनिल नारायण गवली
wrote:
> Dear Friends,
>
> i have to convert the time to given format . format is as follows.
>
> Time Output
> 08:590859
> 17:001700
> 15:30 1530
> 17:05& so on.
> 13:12
> 00:00
Simply use
=TEXT(A2,"hhmm")
Warm Regards,
Ravi Kumar.
-Original Message-
From: excelvbacli...@googlegroups.com
[mailto:excelvbacli...@googlegroups.com] On Behalf Of ??
Sent: Wednesday, September 25, 2013 12:44 PM
To: excel-macros@googlegroups.com; excelvbacli...@googlegr
Dear Friends,
i have to convert the time to given format . format is as follows.
Time Output
08:590859
17:001700
15:30 1530
17:05& so on.
13:12
00:00
08:57
17:15
08:55
17:10
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
--
Are y
19 matches
Mail list logo
