Hi,
Thanks alot. If u give any files with examples in excel or in ppt. it will
help me to learn very easily.
Thanks in advance.
Thanks
Muralidhar E
On Wed, Aug 29, 2012 at 8:25 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Murlidhar,
Some best sites for Array Function
*Could you please inform how to work with this ...*
On Thu, Aug 30, 2012 at 9:59 AM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi,
Kindly see the attached file.
Regards,
Kuldeep Singh
On Thu, Aug 30, 2012 at 1:33 AM, Indrajit $nai talk2indra...@gmail.comwrote:
Hi All,
Can we
Do you have a sheet that you can use to store the current date and a counter?
If not, would you prefer to keep the count within a sheet ( hidden or not)
or in an external file (like C:\temp\FileCount.txt)
?
You can create an Application_Open event macro.
There, read the date from either the cell
Hi Noorin
what is logic of last number 4 in formula if I change it nothing change in
output
={INDEX($B$5:$B$29,SMALL(IF($C$5:$C$29=$G$6,ROW($C$5:$C$29),),ROW(B1))-4)}
I used excel 2003 so I changed formula like this Pl tell me logic of number
4 in last
On Tue, Aug 28, 2012 at 10:16 PM, maksood
I see you have answers but why is YOUR request more URGENT than any other?
Also, use a meaningful subject line and explain your question in the email
and in the file.
etc.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message-
From: PRAVESH
Dear Amar,
We are using No. 4 for row no., If you go through attachment, table start
from row no. 5, row no.4 is heading so, we deduct above all row Number
including header. so we are using 4 because we are deduction 4 row no.
Hope my explanation will help you.
On Thu, Aug 30, 2012 at 5:16
Sure murli,
I will provide u shortly
Sent from BlackBerry® on Airtel
-Original Message-
From: Muralidhar E emuralidha...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 30 Aug 2012 12:44:38
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject:
Sure Murlidhar,
i will provide you shortly.
On Thu, Aug 30, 2012 at 12:44 PM, Muralidhar E emuralidha...@gmail.comwrote:
Hi,
Thanks alot. If u give any files with examples in excel or in ppt. it will
help me to learn very easily.
Thanks in advance.
Thanks
Muralidhar E
On Wed, Aug 29,
Hello,
I have attached a .xlsx with the following values:
A Column = Resolution Time - Formula
is: =MAX(0,TIME(19,0,0)-MAX(MOD(C2,1),TIME(6,0,0)))+
MAX(0,(NETWORKDAYS(INT(C2)+1,INT(B2)-1)))*13/24+
MAX(0,MIN(MOD(B2,1),TIME(19,0,0))-TIME(6,0,0))
B Column = End Date and Time
C Column = Start Date
WithOUT looking at your file(s) something like this pseudo code
‘open each file
for i=1 to 3
sheets(i).usedrange copy
workbooks(“masterfile.xls”).sheets(i).cells(rows.count,1).end(xlup)(2)
next i
‘close each file
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
Dear Guillett,
Thank for the solution. Your answer is perfect.
I wrote below macro for the same project. However it's not working
properly. I tried to put the sum formula to get the total. I think error is
writing the upper cell reference(e.g:G50).
Do you have any idea about getting the correct
Where do you want this IF statement to go?
the format would be:
=IF(OR(D2=Low,D2=Medium),A2,B2-C2)
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people
Your method of looping is inefficient when compared to FIND.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Dilan De Silva
Sent: Thursday, August 30, 2012 8:58 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro to Calculate a total
It IS less efficient,
but if you wanted to fix it...
You're formula is NOT =sum(G1:Gr)
but instead
=sum(G1:G r )
(because you want a string of characters, the VALUE of a variable, then another
string of characters.)
Paul
-
“Do all the good you can,
Option Explicit
Sub merge_multiple_workbooks()
' DECLARE ALL VARIABLES AND ARRAYS
Dim fldpath
Dim fld, fil, FSO As Object
Dim WKB As Workbook
Dim wks As Worksheet
Dim shtnames()
Dim Paste
Dim j As Long, w As Long
Dim stcol As String, lastcol As String
stcol = A
lastcol = iv
With
First post guys!
I am trying to convert dates stored as text into proper formatted UK dates
DD/MM/. A sample spreadsheet is attached. The dates as text are
copied into a variant array, converted to a real date using DateSerial then
copied to a new range using the
If they're in one column...
Select the range
data|text to columns
choose fixed width and remove any lines that excel guessed
choose Date (ymd)
and plop it in the same range as where you picked it up.
And format those (now real) dates the way you want.
Or, a nice ONE liner
Sub
Just append this line after pasting data in the range
Range(E2).Resize(UBound(RealDate), 1).NumberFormat = dd/mm/
Regards,
Lalit Mohan
On Thursday, 30 August 2012 23:27:37 UTC+5:30, RLM wrote:
First post guys!
I am trying to convert dates stored as text into proper formatted UK dates
Job posting is not allow in this forum. You will be banned next time
Sent from BlackBerry® on Airtel
-Original Message-
From: john meridiansoft johnmeridians...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 30 Aug 2012 18:32:18
Reply-To: excel-macros@googlegroups.com
19 matches
Mail list logo