Hi,
I am trying to calculate the number of payments that a customer shall
have to make when purchasing certain realestate products.
**
Assumptions:
#Units being sold:
Years 12
345
Product 15
Please find the attach file with all of you need
Sandeep
- Original Message -
From: Swapnil Palande
To: excel-macros@googlegroups.com
Sent: Thursday, August 20, 2009 7:47 PM
Subject: $$Excel-Macros$$ Re: Using IF, AND, OR Function in Single formula
Hi Dharmesh,
You can
Thanks Raj, But the length of the numbers need not be fixed always. Anyways
I have already got the formula which does this task,
=RIGHT("00"&RIGHT(A1,LEN(A1)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))+1),6)
If you can get me the same task in MS Access it would be great.
Thanks again.
C
What I do is this:
click start, go to run, type cmd
go c:\folder name\ (where the .txt files are stored).
1. make sure only .txt files here are the ones you want to convert
to .xls
2. type rename *.txt *.csv and then all the .txt files will be .csv
files. if you do this often you can make batch
i dont have a file created yet but its simple.
I receive real time market data from third party application and link
to excel so cell A5 will constantly updated.
I would like to capture and sum each price on cell A5 and put to C5.
On Aug 20, 11:45 am, Ometoon wrote:
> Hi there,
>
> Can you g
Hello,
I am trying to assign a number based on the table below. Foir
example, if the number I am testing is greater than 13%, then the
formula would provide 1.30. If the number was -2%, then it would
assign 0.80, etc... I tried using a custom function but can't seem to
get it to work, and a ne
I'm struggling to do something that seems like it would be fairly
straightforward. I'm trying to write some VBA code that sums each
column and each row if the value in the row or column is over a
certain threshold (say over 3, a basic sumif). The problem is that
I'd like the code to work for a v
Hi there,
Can you give some more background information, maybe the file so I can
take
a look at it?
On 20 aug, 15:40, TAlgo wrote:
> Hi,
>
> I have a market data linked to excel through DDE link so prices are
> updated real time.
>
> Cell A5 contains last traded volume which updates whenever
Dear Subu,
Download the cracked version.
http://rapidshare.com/files/239495412/Able2Extract_1_.Professional.v6.0.0.0_Cracked.rar
Thanks & regards,
|| Mudassar Ramzan | MIS Officer | WorldCALL Telecom Ltd | 061- 814-3999 | 0321
7325277 ||
- Original Message -
From: "Subu"
To: "
Hello,
What I want to do is as follows:
I have output in multiple .txt files from a financial system. I want
to convert these files with a macro into excel files with the same
name only a different extension (.xls) making use of the import
function (delimited).
How can I make a script run the ab
Hi Osiso
Below is some code which prints all the month form 1997 to 2009 in
199701,199702 format with a single loop.
To test it just paste it in a module.
If it will not help you then please clearly mention your problem.
Sub month_list()
year_start = 1997
year_end = 2009
months = 199700
i = 1
> Date: Wed, 19 Aug 2009 21:43:22 -0700
> Subject: $$Excel-Macros$$ subtotal under certain conditions
> From: subbu1...@gmail.com
> To: excel-macros@googlegroups.com
>
>
> is there any way i can subtotal rows in Excel report by certain
> Criteria. for example this is the report i have
>
>
>
Dear Mudassar and others
The version in the link below is a TRIAL version and NOT a pro
version...
Do you or someone have the Pro version ? or is there a free ware
somewhere for PDF to XL ?
regards
subu
On Jun 1, 6:09 pm, "Mudassar Ramzan" wrote:
> Dear All!
> Please fin
Any developments / help on this query ?
Thanks in Adv
Regards
Subu
On Aug 18, 11:48 am, Subu wrote:
> Dear members and Ashish Jain
>
> Good morning.
>
> With reference to the thread below
>
> 1. I tried to download this xl sheet
> fromhttp://groups.google.com/group/excel-macros/web/Indian%20St
Hi,
I have a market data linked to excel through DDE link so prices are
updated real time.
Cell A5 contains last traded volume which updates whenever a trade is
done.
I would like to SUM/ADD all last trade volume in cell C5. Is there any
function or macro can help me to do this?
Thx in advance
You can use aray function for this. I will aslo send u solution please send me
your sheet
> Date: Wed, 19 Aug 2009 21:43:22 -0700
> Subject: $$Excel-Macros$$ subtotal under certain conditions
> From: subbu1...@gmail.com
> To: excel-macros@googlegroups.com
>
>
> is there any way i can subto
Hi Dharmesh,
You can create UDF in Visual Basic Editor. You can see the code in VBE.
Go to Tools --> Macro ---> Visual Basic Editor
At the left side of VBE you will get the list of VBA project. This list
shows all the excels currently open.
If you want to see the UDF I have written for RateTabl
hi
question is not v clear... coud u plz gv sm more dummy data and
outcome results.
do u want only the last 3 digits of the data record along with three
preceding zeros? tht cud be done easily as:
=right(a1,3) and cell formatting customized as 00.
Pal.
rajeshpal2...@gmail.com
On Aug 14
Team,
I required support from all of U.
I required some formula which can calculate details of tracking from last
appear.
Pls refer attached file "F" column.
Girish s kale
9426046611
--~--~-~--~~~---~--~~
---
You say that you "have this list".
then: "I have a macro that reads a column and runs these values".
Then: you have to "manually enter in the next 5 months"..
the confusing part here is trying to figure out
where all this information is, where it's coming from and what's happening!
i really ca
Hello,
You can use INDIRECT function, something like
INDIRECT(CONCATENATE(A4;"!$A:$A"))
instead of
KESORAMIND!$A:$A
then name of sheet in formula will be used from cell in column A.
Best regards,
Martin Gasparovic
On Aug 18, 12:36 pm, Subu S wrote:
> Dear Members
>
> I have a spread sheet with
I uploaded as example.xls
On Aug 19, 3:55 pm, venkatesh wrote:
> Hi Mel!
>
> can you please share the worksheet for better understanding.
>
> Venky
>
> On Aug 19, 10:18 am, "melissa.brown"
> wrote:
>
>
>
> > Hi Everyone,
> > I have a shared workbook which contains one sheet for each person in
>
What is a good method to delete all names when starting a macro?
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins
Hi Swapnil
Can u explain how to create userdifined function.
or where to see that function.
Regards
Dharmesh Shah
On Wed, Aug 19, 2009 at 6:56 PM, Swapnil Palande wrote:
> Hi Prasad,
>
> Please find attached excel for solution.
>
> I have write user define function for this.
>
> You have to us
I have this list from '97- 2009 where I run a macro in months 5, 11.
I have another macro that runs between these months (6-10, and 12-4).
For the list below, I have a macro that reads a column and runs these
values.
199705
199711
199805
199811
.
.
.
200905
Currently after I run month 199711 I h
I've shared it as example.xls
On Aug 19, 3:55 pm, venkatesh wrote:
> Hi Mel!
>
> can you please share the worksheet for better understanding.
>
> Venky
>
> On Aug 19, 10:18 am, "melissa.brown"
> wrote:
>
>
>
> > Hi Everyone,
> > I have a shared workbook which contains one sheet for each person
is there any way i can subtotal rows in Excel report by certain
Criteria. for example this is the report i have
Company code Gl codeTotal paid amt
1002 10210 220 USD
1002 23454 10 USD
1002 23567
27 matches
Mail list logo
