Dear All
Can Anyone help me for following problem.
I want to compare 2 column (which are in different different file).
Example, Consider File "A" and File "B" I want to compare column of (File A
,sheet 1, column X) to (File B, sheet 2, Column Y)
There are chances that in (File A ,sheet 1, column X)
Dear Jai...
Please see attachment..
=TEXT(D5-D6,"YY ")&"YEAR, "&TEXT((D5-D6),"mm")&" MONTH,
"&TEXT((D5-D6),"dd")&" DAYS"
Thanks,
Noorain
On Thu, Nov 11, 2010 at 9:47 PM, Jai wrote:
> Dear Groups
>
> First Cell
>
> 20/12/2011
>
> Secound Cell
>
> 12/11/2010
>
> R
Hey Jai,
Supposing the dates are in cells A1 and A2, you can use the following in
cell A3:
=DATEDIF(A2,A1,"y")&IF(DATEDIF(A2,A1,"y")>1," years ,"," year
,")&DATEDIF(A2,A1,"ym")&IF(DATEDIF(A2,A1,"ym")>1," months ,"," month
,")&DATEDIF(A2,A1,"md")&IF(DATEDIF(A2,A1,"md")>1," days left."," day left."
Dear Groups
First Cell
20/12/2011
Secound Cell
12/11/2010
Required Results
1 YEAR ,1 MONTH ,8 DAYS LEFT
DEAR GROUP MEMBER PLEASE HELP ME,
I WANT TO NEED THAT WHEN WE LESS FIRST CELL TO SECOUND CELL
Required Results
1 YEAR ,1 MONTH ,8 DAYS LE
hi experts good morning,
thanks in advance
i want to print in excel sheet cells to 1,2,3,4,5,6,.in the
selected rang, can u help me any one vba code for that macro.
thanking you for kind attention.
--
--
Some impo
I wish to create an auto number Returns Order template.
I've never used VBA or MACROS in Excel before although I did do some
basic stuff with MS Basic back in the DOS days.
I wish to create a template consisting of 10 fields. I would like for
each time the template is opened, an auto generated sequ
Hi Hiren,
Suppose I have a veriable called Fname now I have to get this
variable's value from a Texbox in a user control. Lets take this Text Box
name as Textbox1 now I will use
Fname = Textbox1.value to populate my Fname variable with the value present
in the Text Box. Textbox1.value is the answe
Thanks raj
On 11/10/10, Rajasekhar Praharaju wrote:
> Hi Vilas,
>
>
> Please find the doc attached, which contains the basic procedure for
> recording macros.
>
> Just go through this doc, mean while i will be forwarding you the PowerPoint
> presentation
> in detail.
>
> Thanks,
> Raj
>
> On Wed
Hi,
Please let me know how to obtain the content of a text box of user form?
Thanks
Hiren
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mis-transmission. If you
HI Manjunath
check the attachment next time when you will post any query shoot a new
email...
> On Thu, Nov 11, 2010 at 6:34 PM, P.VIJAYKUMAR wrote:
>
>> Dear All,
>>
>> Here are some of files which may be helpful to our friends.
>>
>>
>> Regards,
>> Vijaykumar
>>
>>
>> --
>>
>>
Hi
I am looking for reporting job in Bangalore. Let us know if any.
Chanra Shekar B
98459 76015
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exc
Excellent one Vijay,Thanks a lot,,
I need a help on the below one,, is it possible to get a formula to solve
this
I need all the data in the column B for the name raju, (no
sum or no count) result should be in each field one data (as in master data)
Hi,
I need a formula for t
Hi everybody
I have an important excel file which i have been working on.
All of a sudden i am not able to open the file
It says it is corrupted
How can i recover the file. I am not able to copy it to another location or
attach the same here.
Trust this group will provide me a solution for this
check the attachment see if it helps you
On Thu, Nov 11, 2010 at 5:02 PM, muralidhar e wrote:
> Dear all group members,
>
> I want to get the L T no, by using vlookup formula, by repeated batches.
> file was attached plz suggest me how to do this by using lookup formula for
> repeated
Dear all group members,
I want to get the L T no, by using vlookup formula, by repeated batches.
file was attached plz suggest me how to do this by using lookup formula for
repeated.Iam using MS-Office 2007.
Warm Regards,
Muralidhar E.
--
It amazing tool bro saves lot of time... keep it up and
thanks a lot for creating and distributing to us...
On Thu, Nov 11, 2010 at 3:36 PM, Ashish Jain wrote:
> Thanks Andy, Anand & Rajesh :) I'm working on making more fast,
> efficient, robust with lot of new user fr
Thanks Andy, Anand & Rajesh :) I'm working on making more fast,
efficient, robust with lot of new user friendly and time-saving tools.
Hope it will be blast !!
Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Spe
Fantastic - Liked it !!
Really helpful :)
Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com
___
Hi Sudheer
Please elaborate your problem last time, I'm not able to understand
the chain mails. I hope, I'll be able to help you out, guide or
atleast learn something from your problem.
Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microso
My pleasure Kush and sorry to see your problem so lately.
Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com
__
Hi Lakshitha
There are many ways to find last row, one of them is using End method
of range.
Here is modified code and try let us know, if it works
---
Sub Macro1()
Dim count As Integer
Dim lstRow As I
*No dear its still pending
*
On Thu, Nov 11, 2010 at 12:59 PM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:
> hello rakesh,
>
> Only for this attached sheet do you have query or Prior chain mails as
> well, then i think u can just use this formula for the attached sheet
> replac
i have a column filled with month names. but not in order here and
there. not in a list.
I want to search for all "sep" in that whole column and put the values
next to it another column. but How to end the loop once it reach the
last "sept" in the column. In other words howt to stop it from endles
hai,
sorry like this, it is not useful for me(for my internal office work). for
my work i want like this only, Is their any possibility like this plz find
the solution, and one more thing is that the batches are like this are
nearly 2,so their is no possiblity to use the pivot table, i check li
Hello Ashish,
Thanks for the reply, I think the solution worked just fine. I aint recevng
those messages regarding "running scripts". thanks a ton buddy. :)
On Wed, Nov 10, 2010 at 12:25 PM, Ashish Jain wrote:
> Hi Kush,
>
> The method explained below will stop annoying you because the
> Intern
Dear Ayush,
Thanks .. it is also usefule for me.
But i dont know VBA aslo. If you can breif in detail path then it will
be great help for me.
Thanks in advance.
Regards,
Darshil Shah.
On Thu, Nov 11, 2010 at 8:38 AM, Ashish Jain <26may.1...@gmail.com> wrote:
> Hi Hemant
>
> You can use these V
Hi Muralidhar,
did u check the attached pivot solution
let me know if it is not apt then i will do v-lookup fucntion as u sent.
Thanks,
Raj
On Thu, Nov 11, 2010 at 12:49 PM, muralidhar e wrote:
> Dear all,
>
> This is urgent to me, plz suggest solution as early as possible.
>
> Warm Regards,
>
27 matches
Mail list logo
