Hi Sudhir,
It is still not clear, how to get the Running Bal and the Pending Amount.
Regards
Umesh
On Sat, Mar 19, 2011 at 12:55 AM, sudhir kumar wrote:
> Dear Experts,
>
>
> Please read my attachment and solve it.
>
> thanx
>
>
>
> <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
Hi Susan,
Assuming that the formula is right. To change the number to time format. Do
it this way mentioned below:-
Right Click the cell -> Click on* format cells* * *-> Select *Time*
from *Category(Number)
*-> Choose the format you want.
Regards
Umesh Dev
On Sat, Mar 19, 2011 at 2:23 AM, Susan
--
--
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://www.linkedin.com/groups?gid=1871310
3. Excel tutor
Question 1.
Dim strPathName As String
Dim intCount As Long
Dim fs, f
What will be the type for variables fs and f?They are not defined in the
variable declaration.
Question 2.
Application.StatusBar = "Now Saving " & GetFileSaveName
ActiveWorkbook.SaveAs _
FileNa
Hi Dave,
Thank you for your response. Sounds like your suggestion should work just fine.
Best regards,
Preston
From: davebonall...@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 18:00:38
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 the range is range1
lets say B1 to B4 name of the range is range2
lets say C1 to C4 name of the range is range3
lets say D1 to D4 name of the range is range4
Dear Experts,
Please read my attachment and solve it.
thanx
<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Sudhir Verma
Asstt. Mngr. A/c's
9818479722
--
--
Some important links for excel users:
1
The data actually pouplates till AS column.When the report is generated it
stops at cloumn AL.
Does this array thing has to do anything about it?
Application.StatusBar = "Please Wait.Loading " & Trim(Prod) & " Data
File"
Workbooks.OpenText FileName:=FileLoc, Origin _
:=xlWindows,
=INT(I3)+CHOOSE(MATCH(I3-INT(I3),{0,0.32999,0.82999},1),0,0.5,1)
or
=IF(ROUND(MOD(I3,1),2)>=0.83,ROUNDUP(I3,0),IF(ROUND(MOD(I3,1),2)>=0.33,TRUNC(I3)+0.5,TRUNC(I3)))
and more..
On Fri, Mar 18, 2011 at 10:42 PM, Rajesh K R wrote:
>
> I want to round the value 16.33 as 16.5 and 16.83 as 17 how ca
Hi Experts
I want to round the value 16.33 as 16.5 and 16.83 as 17 how can I do
it with a formula.
Regards
Rajesh kainikkara
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and l
sample excel sheet would be easier to understand and solve
Reg
Umesh
On Thu, Mar 17, 2011 at 11:20 PM, Preston Moore wrote:
> I am just starting to use VBA so I am a neophyte. I have data that shows
> units sold by product listed by store for over 40 stores. Each store has
> its own ID code a
In the top sticked post is the answer to your question.
http://groups.google.com/group/excel-macros/browse_thread/thread/a18c465d411d0138
Also a quick search of already posted query's will net you several
answers
http://groups.google.com/group/excel-macros/browse_thread/thread/903df336db00c77b
h
Hi
LEN(A1)-LEN(SUBSTITUTE(A1,"@",""))
This part of the formula tells us how many "@" there are in the string. It
compares the length of the original A1 with the length of a modified A1 where
the all "@" are removed. In the case of your example, it's 2.
We then substitute the 2nd instance of "@"
Amazing Dave... very well answered...
Could you please let us know how "~~" this is useful.
Could you please explain or give me a link to understand this.
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
search for the string using Find&Replace Feb 11 - Circle\AA\GA -
AA_F&F_FEB
and replace with Mar 11 - Circle\AA\GA - AA_F&F_MAR
On Thu, Mar 17, 2011 at 10:38 PM, Ankit wrote:
> _MAR_
--
Rakesh kumar khowal
+91 9540084660
+91 9868532105
--
use substitute function
On Fri, Mar 18, 2011 at 1:46 PM, Deepak Rawat wrote:
> Hi Masters,
>
> My query is to remove all the characters after the last "@" from the text.
>
> Example:
> The Raw test is
> deepak@gmail.comkaml...@yahoo.com
>
> The final text i want is deepak@gmail.comkamlesh
>
> Reg
Hi,
You can use an IF combined with LEFT, something like:
IF Left(A2,1)="D" Then (your process code here)
Regards - Dave.
> Date: Thu, 17 Mar 2011 11:39:35 -0700
> Subject: $$Excel-Macros$$ While Looping, looking for cells that start with "D"
> From: walpa...@hotmail.com
> To: excel-macros@googl
Hi,
If your text is in A1, try this in B1:
=LEFT(A1,SEARCH("~~",SUBSTITUTE(A1,"@","~~",LEN(A1)-LEN(SUBSTITUTE(A1,"@",""-1)
Regards - Dave
Date: Fri, 18 Mar 2011 13:46:12 +0530
Subject: $$Excel-Macros$$ Remove text from a string
From: deepakexce...@gmail.com
To: excel-macros@googlegroups.c
=LEFT(A1,FIND("@",A1,FIND("@",A1)+1)-1)
or
=MID(A2,1,FIND("@",A2,FIND("@",A2)+1)-1)
of
array formula
=LEFT(A3,MAX((MID(A3,ROW(INDIRECT("1:"&LEN(A3))),1)="@")*ROW(INDIRECT("1:"&LEN(A3-1)
On Fri, Mar 18, 2011 at 3:16 PM, Deepak Rawat wrote:
> Hi Masters,
>
> My query is to remove all the chara
Hi Masters,
My query is to remove all the characters after the last "@" from the text.
Example:
The Raw test is
deepak@gmail.comkaml...@yahoo.com
The final text i want is deepak@gmail.comkamlesh
Regards,
Deepak Rawat
--
-
Hello All,
Wednesday i have interview (excel and macros) .Can you please help me what
are the basic questions they will ask?
please very urgent
Thankyou
vijay
--
--
Some important links for excel users:
1. Follow u
I am just starting to use VBA so I am a neophyte. I have data that
shows units sold by product listed by store for over 40 stores. Each
store has its own ID code and they all start with the letter "D".
When I encounter each new store I want to copy and past the units sold
of each product to a pre
I am just starting to use VBA so I am a neophyte. I have data that shows units
sold by product listed by store for over 40 stores. Each store has its own ID
code and they all start with the letter "D". When I encounter each new store I
want to copy and past the units sold of each product to a
Guys pls help!!!
On Mar 13, 1:30 pm, Ankit wrote:
> Guys need help in editing links of a worksheet with more than 100
> links like this -
>
> Now excel file is in March'11 folder with below link-
>
> D:\F&F\Feb 11 - Circle\AA\GA - AA_F&F_FEB_2010-11.xlsx
> D:\F&F\Feb 11 - Circle\AB\GA - AB_F&F_FE
24 matches
Mail list logo