Hello everyone;
I am looking for a simple macro to extract information from a text file and
paste it into columns in excel.
I need to extract the the Video File Name, Project Task ID, Date, From
T
On Friday, 12 September 2014 18:38:08 UTC+1, Salvation wrote:
>
> I have two excel workbook with identical columns i need to compare the
> two workbooks to find records that match exactly and those that are likely
> to be similar for further checking. I need help on how to go about it
>
Tha
Hi all,
This is Ahmed Ali. Working as senior QA in Bangalore. Actively learning
macros. Want to thank u all.
On Sep 10, 2014 7:05 PM, "Julian George" wrote:
> Hi All,
>
> I am Julian from hyderabad excel enthusiastic like all you guys
> hereworking as a analyst...
>
>
> --
> Are you
Programmers, like computers (and vice-versa) are extremely literal.
We can programatically compare each row of both sheets
and test for exact matches of all cells in the row.
THAT's fairly straight-forward.
(I'd concatenate all cells in each row of the first sheet and add it to a
Dictionary ob
I have two excel workbook with identical columns i need to compare the two
workbooks to find records that match exactly and those that are likely to
be similar for further checking. I need help on how to go about it
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
hi
yes, if you have excel 2013 you can try DISTINCT function, this will reduce
length of formula...
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Fri, Sep 12, 2014 at 7:53 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Thanks a lot. but its
Thanks a lot. but its there any single formula to do this?
Regards,
Chandra
On Fri, Sep 12, 2014 at 5:31 PM, Ashish Kumar
wrote:
> Vaibhav Bhai, Its superb.
>
>
> Regards
> Ashish
>
> On 12 September 2014 15:38, Vaibhav Joshi wrote:
>
>> Chek this..
>>
>> Cheers!!
>>
>> +
>> *I did not do
Vaibhav Bhai, Its superb.
Regards
Ashish
On 12 September 2014 15:38, Vaibhav Joshi wrote:
> Chek this..
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Fri, Sep 12, 2014 at 2:34 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Fri, Sep 12, 2014 at 3:58 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Thanks a lot
>
> On Fri, Sep 12, 2014 at 3:06 PM, Vaibhav Joshi wrote:
>
>> Chk this..
>>
>> Cheers!!
>>
>> +
>> *I di
Thanks a lot
On Fri, Sep 12, 2014 at 3:06 PM, Vaibhav Joshi wrote:
> Chk this..
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Fri, Sep 12, 2014 at 12:19 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hello Vaibhv,
>>
>> It
Chek this..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Fri, Sep 12, 2014 at 2:34 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hello,
>
> How to get unique values based on two conditions. Could you help me in the
> attached file.
>
> Tha
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Fri, Sep 12, 2014 at 2:47 PM, Rupesh Patil
wrote:
> Hello Vaibhav,
>
> very very thanks, I appreciate your valuable time.
> macro work perfect.
>
> On Fri, Sep 12, 2014 at 2:40 PM, Vaibhav Joshi wrote:
>
>>
Chk this..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Fri, Sep 12, 2014 at 12:19 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hello Vaibhv,
>
> It seems formula is wrong count should be 4 but its giving as 7. Could you
> please check it
Hello Vaibhav,
very very thanks, I appreciate your valuable time.
macro work perfect.
On Fri, Sep 12, 2014 at 2:40 PM, Vaibhav Joshi wrote:
> check this buddy...
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Fri, Sep 12, 2014 at 10:28 AM, R
check this buddy...
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Fri, Sep 12, 2014 at 10:28 AM, Rupesh Patil
wrote:
>
> Hello expert,
>
> I need macro for validate email id.
> following is email id format
>
> anyword.deptn...@dome.ac.in
>
> I have ab
Hello,
How to get unique values based on two conditions. Could you help me in the
attached file.
Thanks in advance
Regards,
Chandru
--
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.face
see this...
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Fri, Sep 12, 2014 at 1:44 PM, Ashish Bhalara
wrote:
> Dear experts,
>
> I am using Concatinate function to merge different text but date field not
> shown as a date in function. Kindly suggest r
Hello Expert,
Does anybody have any idea how to do this.
Please help
On Fri, Sep 12, 2014 at 10:28 AM, Rupesh Patil
wrote:
>
> Hello expert,
>
> I need macro for validate email id.
> following is email id format
>
> anyword.deptn...@dome.ac.in
>
> I have above mails ids format, what validati
Dear experts,
I am using Concatinate function to merge different text but date field not
shown as a date in function. Kindly suggest require changes to merge text
and date.
See the attached file.
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessar
Dear Chandrashekar,
Cells should not be empty. Append 0 and see .
Warm Regards,
Gawli Anil
On Fri, Sep 12, 2014 at 12:19 PM, Chandra Shekar
wrote:
> Hello Vaibhv,
>
> It seems formula is wrong count should be 4 but its giving as 7. Could you
> please check it.
>
> Thanks in advance.
>
> Regard
20 matches
Mail list logo
