Dear Sir
I have downloaded a file from the net but unable to understand the logic in
column Q AND R as the file is read only only so can anyone say me how that
delay had been calculated and interest is calculated...
thanks in advance
regards
LKM
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Exc
Dear Brothers
I am facing problem in the matter of Format borders as i have excel sheet
containing many rows and columns and i have to give border each column
manually so its takes a lot of time. is there any way by which we can copy
only border format in other columns as i have tried paste specia
Brother,
There is any formula based on the conditional formating or sumif based in
which we can recognise about the colour so i want to know that brother
-- Forwarded message --
From: Prince
Date: Thu, Apr 11, 2013 at 5:13 PM
Subject: $$Excel-Macros$$ Re: Sum on the basis of c
Dear All
I need formula for this particular query so please provide me any any
formula instead of macro
Dear All
In the given sheet i want sum on the basis of colour , is there any formula
to solve my problem
regards
L.K.Modi
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you w
Dear All
In the given sheet i want sum on the basis of colour , is there any formula
to solve my problem
regards
L.K.Modi
--
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 official Facebook page of this forum @
https://www.facebook.com/d
Dear all
can any one suggest any formula so that due date get automatically seven of
next month . means if the date is 5-10-12 then due date should be 7-11-12
Regards
L.K.Modi
--
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 official Face
Dear Brother,
What is this xlsm file as this formula is not working in my excel sheet.
On Tue, Feb 19, 2013 at 11:57 AM, अनिल नारायण गवली
wrote:
> Dear ikhan,
>
> Pl find attached herewith.
>
> Warm Regards,
> Gawli Anil
>
> On Tue, Feb 19, 2013 at 11:47 AM, Imran khan wrote:
>
>> Hi,
>>
Bro..
if u are using Excel 2007 it is bulid template named Loan Amortization..
To get this template : Go to Home page : New: Installed template and u
will get what you are looking for ..
Hope this is helpfull to U.. Enjoy ur day..
Thanks
Pankaj Sangotra
On Tue, Feb 19, 2013 at 6:09 AM, L.K
Dear All
I want to Know about the formula to calculate the installment amount:
If loan amount is : 10/-
Years: 3Years
Rate of Interest : 14.50% P.A.
Mode of Insallment :Monthly.
1)What will be the installment amount . Pls suggest by formula
2) If we
sir thats a song file..
On Mon, Sep 3, 2012 at 3:44 PM, अनिल नारायण गवली wrote:
> how can we understand what file u r attaching dude...
> just elaborate and explain...
>
> On Mon, Sep 3, 2012 at 3:40 PM, L.K. Modi wrote:
>
>> sir
>>
>> thats a long song dedic
onth valid only.
>
> Regards,
> Kuldeep Singh
>
> On Mon, Sep 3, 2012 at 3:28 PM, L.K. Modi wrote:
>
>> Dear all
>>
>> as i m uploading file containing size of 25 mb at gmail to send but its
>> shows error so suggest how can we short the size of a fold
Dear all
as i m uploading file containing size of 25 mb at gmail to send but its
shows error so suggest how can we short the size of a folder.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use
Dear All,
Its good to see this resolution but can anyone explain this in simple
way
Regards
Modi
On Thu, Mar 22, 2012 at 4:51 AM, dguillett1 wrote:
> Option Explicit
> Sub getmiddleSAS()
> Dim c As Range
> Dim fs As Long
> Dim ls As Long
> For Each c In Range("a2:a10")
> c = Applic
Dear Sir,
Earlier i was able to download file from the excel group. I want to
download some useful files from there . can any one send me that link.
Regards
LKModi
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Pleas
Dear All members,
I am attaching herewith a file regarding tds and the requirement is mention
in that file related to subtotal and conditions. Please solve my problem .
Thanks to all in advance
Regards
LKModi
9309243685
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise
Dear Members
I want to know about the new advanced excel formulas and addins. Please send
me some useful links or files by which i can know about that by downloading
all that.Specially if those links also having finance related funcion or
addins that will great for me also.
Thanking you
Regard
Dear Members,
Thanks for your valuable support. I have an querry in which i have to check
interest calculation for banks.
Me attaching a sheet in which column A have date that is in different
format. and in column B the balance as on the respective dates.
As the bank charges interest on the clos
THANKS A LOT MY PROBLEM IS SOLVED NOW BY THESE VALUABLE MEMBERS
REGARDS
LKMODI
On Thu, Jul 7, 2011 at 10:25 AM, L.K. Modi wrote:
> Dear Members,
>
> Me attaching a sheet which relates to Excise duty payment.The result should
> be 5 of the next of the month of Invoice.We are cur
Dear Members,
Me attaching a sheet which relates to Excise duty payment.The result should
be 5 of the next of the month of Invoice.We are currently doing it
manually. But is there any formula by which we can do that fast and in less
time. Hope you wil surely help me.
Regards
LKModi
--
Dear Members
I have a query regarding conditional formating:
1. I have a sheet in which some cells containg amounts out of those some
cells are coloured.
Is there any way to coloured only those coloured cells. One way i have by
filter on the basis of colour but everytime to use that is hectic so
Dear Members,
with reference to the above dear member i want a excel sheet. Earlier i have
downloaded a sheet that updates automatically bse and nse prices. Similary
is there any way by which when i would run macro the LME prices and
Commodities Prices update automatically.
May be its a challengin
Dear Group Members
I need an excel file in wihch by running macro we can see our IP ADDRESS.
Please provide me that file by which we can know the IP address of our
System
Regards
LKModi
--
--
Some important links
ru all file in files collection
>For Each MyFile In FOL
> If LCase(Right(MyFile.Name, 4)) Like "*xl*" Then
> r = r + 1
> Range("B6").Cells(r, 1) = r
> ' - get the name and write to cell
> Range("B6").Cells(r, 2) = MyFile
Dear GroupMembers,
I want to list the file name that are in closed folder .Means any way by
which i can get the files or workboooks name that are in a particular
folder.
Thanks in advance
Regards
LKModi
--
--
S
this add in is not working
On Wed, Mar 30, 2011 at 10:42 AM, ashish koul wrote:
> try this addin see if it helps
>
> http://www.rondebruin.nl/mail/add-in.htm
>
>
>
>
> On Tue, Mar 29, 2011 at 8:02 PM, shariq khan wrote:
>
>> Can any one help me?
>>
>>
>>
>> I looking for code to send an emai
).Select
> Selection.End(xlUp).Select
>
> k = ActiveCell.Row
>
>
>
>
>For i = 5 To k + z Step 1
>
>
>
>If (i Mod j = 0) Then
>
>ActiveSheet.Cells(i + z, 1).Select
>
>Selection.EntireRow.Insert
>
>
> z = z + 1
>
>
> En
Dear all
can any one help me in inserting black rows after line no.5
like 5 then blank row then 6 and then again blank row and again
regards
LKModi
--
--
Some important links for excel users:
1. Follow us on TWIT
IS THERE ANY GOOD PERSON/INSTITUTE TO LEARN ADVANCE EXCEL AND VBA MACROS AT
JAIPUR.
PLEASE SUGGEST ME.
AWAITING FOR YOUR RESPONSE.
REGARDS
AMIT
--
--
Some important links for excel users:
1. Follow us on TWITTER
pls send some new utility and asap and power utils are older more than 1
years
if u can pls send some new utilities we all be greatful to you.
thanks in advance
Regards
LKModi
On Sat, Nov 13, 2010 at 3:44 PM, Vishal Angre wrote:
> use this addin for all excel version
>
> http://www.asap-u
Dear All
Earlier i had got an excel file in which bse prices are automatically
updated like that way i need to track lme prices. can any one help on this .
Regards
LKModi
--
--
Some important links for excel users:
Dear all
As per your mail i am unable to find what is the radio buttons. as i m new
to excel.
can any one suggest the entire procedure regarding these radio buttons and
use.
pls ignore the mail if i have already sent the mail. I want to know the step
by step procedure regarding these buttons
Th
Dear all
As per your mail i am unable to find what is the radio buttons. as i m new
to excel.
can any one suggest the entire procedure regarding these radio buttons and
use.
Thanks in advance hope i wil get the reply fast.
Regards
LKModi
On Sun, Jun 27, 2010 at 9:34 PM, ayush jain wrote:
Dear all Group Members
I have joined this group for my development and i have learnt a lot from
here.
Really this is group is one of the best groups to learn for going ahead. I m
an accounting person and i have to give my top management many type of
reports like fund position,debtors,creditors,sal
Dear Sir (Regarding Pop up on a sheet)
> May i know how u do this step by step.I am a great fan of this group.
> because in the sample sheet i m unable to know the process.Hope i will get
> answer shortly
>
> Regards
> LKModi
>
>
>
>
>
>
> On Wed, Jun 9, 2010 at 6:43 AM, Harpreet Singh Gujral <
>
Dear Sir
May i know how u do this step by step.I am a great fan of this group.
because in the sample sheet i m unable to know the process.Hope i will get
answer shortly
Regards
LKModi
On Wed, Jun 9, 2010 at 6:43 AM, Harpreet Singh Gujral <
harpreetguj...@gmail.com> wrote:
> Swapnil,
>
> You
sorry did not get select the funcion and presss tab can u expalin this dear
friend
On Fri, May 7, 2010 at 11:54 AM, Sandeep Kumar Maurya wrote:
> Select the function and press tab.
>
> Thanks & Regards
> Sandeep
>
>
> On Thu, May 6, 2010 at 11:38 PM, Michael wrote:
>
>> I posted a picture
> Dear all group Members,
>
> I am also a member of your very good group.
> I am very pleased to be in this group becasue i have learned a lot of excel
> from here.
> i would like to mention that in these days there is no mail i had received
> that contains attachment file from where i can understa
Dear all group Members,
I am also a member of your very good group.
I am very pleased to be in this group becasue i have learned a lot of excel
from here.
i would like to mention that in these days there is no mail i had received
that contains attachment file from where i can understand the proble
may i know what is the use of this password cracker
Actually me new to this group. Pls dont take otherwise
this group is very good and i have learned many things from here that i
thought can not be possible.
Thanks for ur much good support thanks to all member of group
Regards
LKModi
On Fri,
Dear Aindril
As i m seeing this mail there is no link at all in your mail. Is there any
way to calculate networking days
Regards
LKModi
On Wed, Apr 7, 2010 at 2:20 PM, Aindril De wrote:
> Hi Roopesh,
>
> The process given in the link below will be a good start.
> Regards,
> Aindril
> On W
Dear Sir
May i know how can we use that excel tool tip file.
sry i m new to excel but like this group much its help me a lot
pls tell me the way how can we use that
as i m clicking on that there is some id type is there and nothing else
please suggest me
Regards
On 4/6/10, rf1234 rf1234 wrote
Dear Sir
May i know how can we use that excel tool tip file.
sry i m new to excel but like this group much its help me a lot
pls tell me the way how can we use that
as i m clicking on that there is some id type is there and nothing else
please suggest me
Regards
LKmodi
On 4/6/10, rf1234
Dear All
if there is a coloum containg mix of nos and alphabets
like ram12
moh12345an
132shyam
we need only alphabets what can we do
like ram
mohan
shyam
Here we can seprate only nos. but what can we do if we want alphabets
sepreately.
Help in this query.
Thanks in advance
Regards
LKModi
Dear All
if there is a coloum containg mix of nos and alphabets
like ram12
moh12345an
132shyam
we need only alphabets what can we do
like ram
mohan
shyam
Here we can seprate only nos. but what can we do if we want alphabets
sepreately.
Help in this query.
Thanks in advance
Regards
LKModi
44 matches
Mail list logo