*=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(Ar
hi syed,
find the attached without array.
--
*Thanks & Regards
Thamu
*
On Fri, Apr 8, 2011 at 2:45 AM, syed aliya raza hashim
wrote:
> 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
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 hav
see if it helps
On Fri, Apr 8, 2011 at 2:45 AM, syed aliya raza hashim
wrote:
> 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
>
>
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: Carl,Ch
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 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
> w
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
--
---
Thank you very much!
On Thu, Apr 7, 2011 at 7:32 AM, rajan verma wrote:
> 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 to 125 then
Ashish,
Perfect! Thank you for your patience and your teaching.
John
On Thu, Apr 7, 2011 at 11:22 AM, ashish koul 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
> wrote:
>
>> Ashish,
>>
>> I have attac
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 =
split(Range(cell
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 wrote:
> 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 n
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 = Hour(Range(Ce
try this with this you can add text part of signature not graphics
On Thu, Apr 7, 2011 at 5:51 PM, Sanjoy Nath wrote:
> 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
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 wrote:
> Its awesome.Hats off to Ashish.
> Regards,
> C.G.
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
use averageif() Function instead of Average(if())
Rajan.
On Wed, Apr 6, 2011 at 2:09 PM, syed aliya raza hashim
wrote:
>
> 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 suggestion where can
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 :45
hi,
i did not ever use the phonetic property of a cell. but probably it will
possible with that..
2011/4/5 VIn@Y
> 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 "西洋勁曲" inside code
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 : excel-mac
Congratulation ashish.
On Wed, Apr 6, 2011 at 5:29 PM, Jorge Marques 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 Aindril De
>
>> Co
20 matches
Mail list logo
