Hi Sriram,
Vlookup is used to pick values from tables for lookup values...
For more details use techonthenet.com.. This is an awesome website.. If
face any challenge then let me know..
On Aug 31, 2012 12:22 PM, "sriram ji" wrote:
> Dear Excel Guru,
>
> May I know how to vlookup 2003 Excel to 20
Dear Sriram,
Please explain your query,if possible pls share a sample workbook with
group.
On Fri, Aug 31, 2012 at 12:22 PM, sriram ji wrote:
> Dear Excel Guru,
>
> May I know how to vlookup 2003 Excel to 2007 excel...
>
> Thanks & Regards,
> Sriram G (chennai)
>
> --
> Join official facebook p
Dear Excel Guru,
May I know how to vlookup 2003 Excel to 2007 excel...
Thanks & Regards,
Sriram G (chennai)
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Po
Job posting is not allow in this forum. You will be banned next time
Sent from BlackBerry® on Airtel
-Original Message-
From: john meridiansoft
Sender: excel-macros@googlegroups.com
Date: Thu, 30 Aug 2012 18:32:18
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgen
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 d
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 ConvertStringToDa
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 WorksheetFunction.Transp
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 Application.
It IS less efficient,
but if you wanted to fix it...
You're formula is NOT "=sum(G1:G&r)"
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 yo
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 upon
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 peo
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 ce
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
From
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
Sure Murlidhar,
i will provide you shortly.
On Thu, Aug 30, 2012 at 12:44 PM, Muralidhar E wrote:
> 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 P
Sure murli,
I will provide u shortly
Sent from BlackBerry® on Airtel
-Original Message-
From: Muralidhar E
Sender: excel-macros@googlegroups.com
Date: Thu, 30 Aug 2012 12:44:38
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Learn Array formula's
Hi,
Than
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 P
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 K
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
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 o
*Could you please inform how to work with this ...*
On Thu, Aug 30, 2012 at 9:59 AM, Kuldeep Singh wrote:
>
> Hi,
>
> Kindly see the attached file.
>
> Regards,
> Kuldeep Singh
>
> On Thu, Aug 30, 2012 at 1:33 AM, Indrajit $nai wrote:
>
>> Hi All,
>>
>> Can we track through VBA, how many time I'
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 wrote:
> Dear Murlidhar,
>
> Some best sites for Array Function
>
> http://www.cpearson.com/excel/A
22 matches
Mail list logo
