try this
select the folder in which you have saved the html files
On Sat, Mar 19, 2011 at 2:33 PM, Chidurala, Shrinivas <
shrinivas.chidur...@citi.com> wrote:
> Ashish,
>
> Find attached sample file as requested.
>
> Regards,
> Shrinivas
> Citi® Global Transaction Services - India
>
> UB City,
Thanks that helped. Sometimes when the obvious doesn't work, do the
opposite. Like find the formula that fixes the error J
And thanks for catching my error in column T.
Reminder: don't use your personal email to reply to a question. When you
do it , your answer won't post to the group
Hi Susan,
U5:U19, Format to mil. time, then paste
=IFERROR(AVERAGEIF($F$5:$F$17,"=1",$G$5:$G$17),"No Occurrence") in U5:U15,
with the "=1" changing to the right value in the cells. Format the data
ranges in numeric format without decimals. Not sure why you are summing the
values in column T ins
Hi Santosh,
Use the following code for combo criteria - Command button 5
Private Sub CommandButton5_Click()
Dim A As Integer
Dim B As Integer
Dim c As Integer
Dim d As String
A = TextBox1.Value
B = TextBox2.Value
d = ComboBox1.Value
c = A * B
If d = "OTHERS" Then
TextBox3.Value = c * 45 / 100
Els
Hi Santosh,
You have declared number variables as Integer, which have a maximum allowance
of (approx) +/- 32000.
Dim A As Integer
Dim B As Integer
Dim c As Integer
Try declaring them as Long
Dim A As Long
Dim B As Long
Dim c As Long
Regards - Dave.
Date: Sat, 19 Mar 2011 20:22:18 +0530
Hi Umesh,
I tried changing the format via from the format cells and Excel changed the
number to 0:00.
The formula =TIME works fine, how do I incorporate that formula into my
=Average formula?
=AVERAGEIF($F$5:$F$17,"=1",$G$5:$G$17) =TIME
That didn't work , then I tried
=(TIME(AVERAGEIF
Hi Friends,
Need a small help.
Attached is a excel with a comand button which will populate a userform.
In the userform there is a comand button called use combo which should
calculate based on the combobox criteria.
This is what not calculating properly.
--
Regards
Santosh
santoshkumar.subu.
thankyou very much
On Sat, Mar 19, 2011 at 6:17 PM, sudhir kumar wrote:
> Dear
>
> Please find the attachment and reply me your query solved or not.
>
> thankx
>
>
> On 19/03/2011, vijayajith VA wrote:
> > hello all,
> >
> > Please see the attached file
> >
> > Thankyou
> >
> > --
> >
> ---
"=SUMIF(A3:B24,"Reebok",B3:B24)" Use this formula Veriety wise total..
-- Forwarded message --
From: vijayajith VA
Date: Sat, 19 Mar 2011 14:42:47 +0530
Subject: $$Excel-Macros$$ i need a help
To: excel-macros@googlegroups.com
hello all,
Please see the attached file
Thank
Dear
Please find the attachment and reply me your query solved or not.
thankx
On 19/03/2011, vijayajith VA wrote:
> hello all,
>
> Please see the attached file
>
> Thankyou
>
> --
> --
> Some important links for ex
hello all,
Please see the attached file
Thankyou
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://
Ashish,
Find attached sample file as requested.
Regards,
Shrinivas
Citi(r) Global Transaction Services - India
UB City, Canberra Block, # 24, Vittal Mallya Road,
Bangalore - 56 00 01.
Ph- +91-80-4144 6339 / 6340
Email - shrinivas.chidur...@citi.com
From: e
hi ashish
the same will work in 2003
--
*Thanks & Regards
Thamu
*
On Sat, Mar 19, 2011 at 1:56 PM, ashish koul wrote:
> try this (excel 2007) i haven't tested it on 2003
>
>
> press f3 and click on paste list
>
>
>
>
>
> On Fri, Mar 18, 2011 at 10:27 PM, hanumant shinde <
> hanumant_5...@yah
Dear All,
Please any help in me on below mail.
Regards,
Shrinivas
Citi(r) Global Transaction Services - India
UB City, Canberra Block, # 24, Vittal Mallya Road,
Bangalore - 56 00 01.
Ph- +91-80-4144 6339 / 6340
Email - shrinivas.chidur...@citi.com
-Original Message-
From: excel-macr
Hi
Running balance mean's outstanding of Parties on left side display date.
Pending amount mean's pending bills upto outstanding.
thanx
On 19 March 2011 05:27, Umesh Dev wrote:
> Hi Sudhir,
>
> It is still not clear, how to get the Running Bal and the Pending Amount.
>
>
> Regards
> Umesh
>
i need your help
my question is "Excel, auto-find duplications when inputting data in
different sheets?"
help me out as early as u can my dear
--
--
Some important links for excel users:
1. Follow us on TWITTER for
Hi Akbar,
checkout the attachment and revert if it is not helpful.
--
*Thanks & Regards
Thamu
*
On Sat, Mar 19, 2011 at 9:14 AM, Muhammad Talal Akbar <
sh.talal.ak...@gmail.com> wrote:
>
>
> --
>
> --
> Some impo
can u send the sample file
On Thu, Mar 17, 2011 at 3:20 PM, Chidurala, Shrinivas <
shrinivas.chidur...@citi.com> wrote:
> Dear All,
>
> We received some HTML files from System and we save as them in Excel file
> and do some formatting. Can we do this activity of converting HTML file to
> Excel by
try this (excel 2007) i haven't tested it on 2003
press f3 and click on paste list
On Fri, Mar 18, 2011 at 10:27 PM, hanumant shinde wrote:
> Hi friends,
>
> i want to find out all the namedranges from worksheet / workbook. can
> somebody please help me.
>
> eg. lets say A1 to A4 name of th
You're welcome
Dave
From: walpa...@hotmail.com
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ While Looping, looking for cells that start with
"D"
Date: Fri, 18 Mar 2011 15:55:08 -0600
Hi Dave,
Thank you for your response. Sounds like your suggestion should work just fin
20 matches
Mail list logo
