Hi
You can do that with simple Vlookup function.
Rgds
On Thursday, October 18, 2012 3:25:30 PM UTC+5:30, Manoj Kumar wrote:
>
> Hi,
>
> I want to know if coll "A" Data found in Coll "C", it found the value of
> Coll "A". using sumproduct..
>
>
> On Thu, Oct 18, 2012 at 3:08 PM, Vabz > wrote:
>
Hi
Then you are getting correcr answer, try Multiplying 1 with Text Value eg.
1 x V5/A & G-040 results in to #VALUE!.
You can get values only data is non text one.
Rgds//Vabs
On Thursday, October 18, 2012 3:25:30 PM UTC+5:30, Manoj Kumar wrote:
>
> Hi,
>
> I want to know if coll "A" Data found
Hi
What exactly you are trying to do.
Rgds//Vabs
On Thursday, October 18, 2012 3:05:31 PM UTC+5:30, Manoj Kumar wrote:
>
> Dear Expert,
>
> please help tell me i am doing something wrong in this formula..
> A B c Store ID Store ID V5/A & G-199 #VALUE! V5/A & G-016 V5/A &
> G-016 #VALUE!
Hi Sudhir,
Simply use Subtraction Operator.i.e. Hyphen(-) to do this.
For e.g. if A1 is 1/12/2010 and B1 is 31/12/2010, then formula would be
B1-A1+1 to calculate the total days between two dates.
PS: If you need business working days, then use NETWORKDAYS(A1,B1) to
calculate working days betw
I have solved this with the following code but I can not get it to
continuously run can anyone help
Sub Get_Max1()
If Range("b2").Value < Range("c1").Value Then
Range("b2").Value = Range("c1").Value
End If
End Sub
Thanks
Sacha
--
--
- Original Message -
From: Sandeep
To: excel-macros@googlegroups.com
Sent: Sunday, August 23, 2009 2:27 PM
Subject: Re: $$Excel-Macros$$ Re: Please Help Me!!!***Solved***
Hi Everyone,
I solved my problem of ranking. Here is attach solution
Thanks Everyone for helping me. Specially
cros@googlegroups.com
Sent: Sunday, August 23, 2009 12:05 AM
Subject: $$Excel-Macros$$ Re: Please Help Me!!!
Hi Anil + jonell,
Thanks for considering my problem.
Yes the Total is also based on the grace marks.
Thanks & Regards
Sandeep
- Original Message -
From: jonell
Hi Anil + jonell,
Thanks for considering my problem.
Yes the Total is also based on the grace marks.
Thanks & Regards
Sandeep
- Original Message -
From: jonell
To: excel-macros@googlegroups.com
Sent: Thursday, August 13, 2009 12:39 PM
Subject: $$Excel-Macros$$ Please Help M
Hi Amresh,
Could you please clarify!! "Workbook in Word"
Please send a sample file.
Regards,
Andy
On Mon, Aug 17, 2009 at 7:15 PM, amresh kumar wrote:
> Dear Freinds,
>
> please help me
>
>
> i have a workbook in word there are many pages in workbook but i want
> Separate
> workbook
-macros@googlegroups.com
Cc: sandymau...@gmail.com
Sent: Tuesday, August 11, 2009 2:21 AM
Subject: $$Excel-Macros$$ Re: Please Help Me!!!
Hi Anil,
Please find the attached sheet with answer of your query.
Regards,
Deepak Rai
On Mon, Aug 10, 2009 at 12:07 PM, Sandeep wrote:
I
Hi Anil,
Please find the attached sheet with answer of your query.
Regards,
Deepak Rai
On Mon, Aug 10, 2009 at 12:07 PM, Sandeep wrote:
> I Need to calculate the range as per the criteria mentioned in attached
> file please help me.
>
> >
>
>
--
Thanks,
Deepak Rai
--~--~-~--~---
screen the file attached. That also includes
> solution to your first step which has been omitted in previous version of
> the code.
>
>
> Regards.
>
>
> Serghei
>
> ------------------
> From: oserg...@hotmail.com
> To: excel-macros@googlegroups.com
&g
t;Visual Basic Editor screen the file attached. That also includes
> solution to your first step which has been omitted in previous version of
> the code.
>
>
> Regards.
>
>
> Serghei
>
> ------
> From: oserg...@hotmail.com
> To: excel-macros@goo
oserg...@hotmail.com
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Re: Please help me to solve this problem
Date: Thu, 30 Jul 2009 14:58:28 +
Hi Swapnil,
I have attached a text document with the VBA macro code which addresses your
problem. All you need to do is copy+paste th
Try entering the values for the mentioned scenarios and confirm if the same is
working.
Regards.
Serghei.
From: swapnilp1...@gmail.com
Date: Thu, 30 Jul 2009 19:55:30 +0530
Subject: $$Excel-Macros$$ Re: Please help me to solve this problem
To: excel-macros@googlegroups.com
Hi S
Hi Serghei,
Thanks for giving reply.
I saw you excel, but it is not solving my problem. I am not able to find
macro written in your excel.
I want to apply conditional formatting on Major suppliers columns "PP" and
"PE" i.e. column M and N
Suppose If I insert supplier name in "PP" column (i.e. c
find attached file
Regards,
v...@l p...@ndya
On Wed, Feb 4, 2009 at 3:05 PM, shay shay wrote:
>
> please help me with count function
> --
> Shay
>
> A Thinker tends to use reason and logic
>
> A feeler tends to use values and subjective Judgement.
>
> Be a Thinker in Life.
>
> >
>
--~--~--
17 matches
Mail list logo
