Thanks alot Daniel
On Mon, Apr 4, 2011 at 2:38 PM, Daniel dcolarde...@free.fr wrote:
Hi,
Paste this macro in the first workbook. Open it manually and run the “Test”
macro.
Sub test()
Dim lgRow As Long, sh As Worksheet, c As Range, rg As Range
Const strPath As String =
Congratulation ashish.
On Wed, Apr 6, 2011 at 5:29 PM, Jorge Marques leote.w...@gmail.com wrote:
Congratulations Ashish especially for your help and also to this forum, i
have to say my learnings in macro are exponential since this was created, i
was a zero at the beginning!
2011/4/6
Hi,
In K3 (array formula, validate with Ctrl+Shift+Enter) :
=IF(ISERROR(AVERAGE(IF((MONTH($B$2:$B$125)=MONTH(J3))*(YEAR($B$2:$B$125)=YEA
R(J3))0,$E$2:$E$125))),,AVERAGE(IF((MONTH($B$2:$B$125)=MONTH(J3))*(YEAR(
$B$2:$B$125)=YEAR(J3)),$E$2:$E$125)))
Regards.
Daniel
De :
hi,
i did not ever use the phonetic property of a cell. but probably it will
possible with that..
2011/4/5 VIn@Y vinayshett...@gmail.com
To be more clear I want to write the translation of same word POP in
Chinese language into text file or excel sheet but when I am writing that
Chinese word
I'm having an issue where I'm trying to separate a cell with time in
it, for example the cell would conta 8:56:45 and I need each one of
those numbers into it's on cell so A1 = 8 A2 =56 A3=45. So far I've
been able to ge this to work however the system sends the information
will send data like
use averageif() Function instead of Average(if())
Rajan.
On Wed, Apr 6, 2011 at 2:09 PM, syed aliya raza hashim
hashim...@gmail.comwrote:
Hi in this formula if i am incresing the range 25 to 125 then it is
counting blank cell also and traeting blank cell as a jan month so is there
any
Dear Ayush,
Now a categorisation is very necessary where all the helps and supports
recieved and asked should get categorised according to
1.Functional requirements
2.Excel Features Wise
3.Support Providerwise
With the Excel Files attached in each case such that users can access the
previously
Thanks a lot
There is a problem to send the emails with graphics signatures , and the
preset signatures are not getting into the email.
Please provide some help to do macros in outlook also
On Thu, Apr 7, 2011 at 11:07 AM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:
Its awesome.Hats off to
try this with this you can add text part of signature not graphics
On Thu, Apr 7, 2011 at 5:51 PM, Sanjoy Nath sanjoy.nath...@gmail.comwrote:
Thanks a lot
There is a problem to send the emails with graphics signatures , and the
preset signatures are not getting into the email.
Please
When I ran your code I got an error on this line:
Range(L2) = LHour
... and had to add parens around the L2, comme ca:
Range(L2) = LHour
If that still doesn't run, you might try this construct:
If IsError(Hour(Range(CellAlpha))) Then
LHour = 0
Range(L2) = LHour
Else
LHour =
Assuming the time is a text, and not a time value, use
Range(L2).offset(0,1).resize(1,3).value =
split(Range(cellalpha).value,:)
On Apr 7, 5:11 pm, Speilman_54 mbed...@gmail.com wrote:
I'm having an issue where I'm trying to separate a cell with time in
it, for example the cell would conta
Please forgive me I'm not the best programmer. The cells are
initially a custom field but if you change them to text it isn't
making a difference because of the : starting value
Is it possible that you could break down what this is doing
Range(L2).offset(0,1).resize(1,3).value =
Ashish,
Perfect! Thank you for your patience and your teaching.
John
On Thu, Apr 7, 2011 at 11:22 AM, ashish koul koul.ash...@gmail.com wrote:
try this
run macro to merge the data and check sheet 2 and 3 for formula
On Tue, Apr 5, 2011 at 11:10 PM, John A. Smith
Thank you very much!
On Thu, Apr 7, 2011 at 7:32 AM, rajan verma rajanverma1...@gmail.comwrote:
use averageif() Function instead of Average(if())
Rajan.
On Wed, Apr 6, 2011 at 2:09 PM, syed aliya raza hashim
hashim...@gmail.com wrote:
Hi in this formula if i am incresing the range 25
Hi,
Hi i have attached my file i want in sheet 2 there are column c in that i
want the name from sheet 1 but there are two condition first is match by ID
then match by Name as well then how can we do this
--
syed aliya
--
Ashish,
One more thing please; that macro in a 2007 format? I ran out of columns.
Thank you again.
John
On Thu, Apr 7, 2011 at 11:22 AM, ashish koul koul.ash...@gmail.com wrote:
try this
run macro to merge the data and check sheet 2 and 3 for formula
On Tue, Apr 5, 2011 at 11:10 PM,
I'd like a function script that compares the strings from two cells,
and returns, in a third cell, the parts of the 2nd string that do not
match parts of the 1st string (I don't need to return the parts of 1st
string that do not match parts of the 2nd string).
Examples:
Cell1: Chris
Cell2:
see if it helps
On Fri, Apr 8, 2011 at 2:45 AM, syed aliya raza hashim
hashim...@gmail.comwrote:
Hi,
Hi i have attached my file i want in sheet 2 there are column c in that i
want the name from sheet 1 but there are two condition first is match by ID
then match by Name as well then how can
I have a similar issue. I have 4 workbooks basically (dumb info 1, dumb info 2,
etc). The layout/format of the four are the same. The first 76 sheets of each
book contains the data. Another 5-10 sheets are use to consolidate. With dumb
info 4 I got playing around with graphs and charts. So I
hi syed,
find the attached without array.
--
*Thanks Regards
Thamu
*
On Fri, Apr 8, 2011 at 2:45 AM, syed aliya raza hashim
hashim...@gmail.comwrote:
Hi,
Hi i have attached my file i want in sheet 2 there are column c in that i
want the name from sheet 1 but there are two condition first
*=TextDif(A2,B2)*
TextDif is an UDF, like this:
Function TextDif(S1 As String, S2 As String) As String
Dim Arr1, Arr2
Dim n As Integer, i As Integer, t As String
Arr1 = Split(S1, ,): Arr2 = Split(S2, ,)
For i = LBound(Arr2) To UBound(Arr2)
For n = LBound(Arr1) To UBound(Arr1)
21 matches
Mail list logo