$$Excel-Macros$$ Re: Duplicate with party

2009-08-28 Thread Dilip Pandey 
Dear Vidyut,

Attached the file as per your requirements.

Thanks & Best Regards,
-- 
DILIP KUMAR PANDEY
   MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062


On 8/29/09, vidyut more  wrote:
>
> Hi,
> Dilip. Thanks Again. But i want formula that will look party name and
> inv.no. i am attaching ur sheet and query in that sheet.
> Thanks in advance.
>
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Duplicates - by DILipandey v1.1.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Advanced conditional formatting

2009-08-28 Thread Dilip Pandey 
Hi Liuxin,

Thanks for the encouraging words...!!

Best Regards,
-- 
DILIP KUMAR PANDEY
   MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062


On 8/28/09, liuxin9...@gmail.com  wrote:
>
>
> hi,your answer is very good.
> When using the relative reference, the first cell in the row gets the
> right answer.
> However, when it happens in the next cell, the formula changes because
> I am using the relative reference.
>
> On Aug 28, 12:35 pm, Dilip Pandey  wrote:
> > Hi Liuxin,
> >
> > This is because, when you use absolute reference ($ref$), conditional
> > formatting logics on the entire row is checking if that particular
> reference
> > is meeting the logics or not.  Moreover, when you apply that logic
> towards
> > right direction to cover entire row, the logic still checks only that
> > particular reference, which is still meeting up with the criteria defined
> > and hence, entire row gets colored.
> >
> > For more details, refer to the attachement which I just forwarded to
> Suresh
> > and "Group".
> >
> > Let me know in case of any queries.  Thanks
> >
> > --
> > DILIP KUMAR PANDEY
> >MBA-HR,B COM(Hons.),BCA
> > Mobile: +91 9810929744
> > dilipan...@gmail.com
> > dilipan...@yahoo.com
> > New Delhi - 110062
> >
> > On 8/27/09, liuxin9...@gmail.com  wrote:
> >
> >
> >
> >
> >
> > > I have a question.
> > > When I use the relative reference in the formula, there is only one
> > > cell colored.
> > > While if I use the absolute reference, the complete row is colored,
> > > why?
> >
> > > On 8月27日, 下午10时53分, Dilip Pandey  wrote:
> > > > Dear Suresh,  I think you forgot to attach the file.  Please
> re-attach
> > > and
> > > > send.  Thanks.
> > > > --
> > > > DILIP KUMAR PANDEY
> > > >   MBA-HR,B COM(Hons.),BCA
> > > > Mobile: +91 9810929744
> > > > dilipan...@gmail.com
> > > > dilipan...@yahoo.com
> > > > New Delhi - 110062
> >
> > > > On Thu, Aug 27, 2009 at 8:17 PM, suresh k 
> > > wrote:
> > > > > Hi Dilip,
> >
> > > > > Can you check this attachment. Its having three options "TRUE",
> "FALSE"
> > > and
> > > > > "Not available. In this case is it possible to highlight entire
> rows in
> > > > > different color based on the result.
> >
> > > > > On Thu, Aug 27, 2009 at 8:03 PM, Dilip Pandey <
> dilipan...@gmail.com
> > > >wrote:
> >
> > > > >> Hi Suresh.
> >
> > > > >> Attached file has the scenario and the explanation for your
> > > query.  Thanks
> >
> > > > >> --
> > > > >> DILIP KUMAR PANDEY
> > > > >>   MBA-HR,B COM(Hons.),BCA
> > > > >> Mobile: +91 9810929744
> > > > >> dilipan...@gmail.com
> > > > >> dilipan...@yahoo.com
> > > > >> New Delhi - 110062
> >
> > > > >> On Thu, Aug 27, 2009 at 4:51 PM, suresh k  >
> > > wrote:
> >
> > > > >>> Hi Guyz,
> >
> > > > >>> Whenever we use conditional formatting it will be applied for
> current
> > > > >>> cell only.
> >
> > > > >>> Is there anyway that if the condition is true the entire row
> should
> > > be
> > > > >>> colored???
> >
> > > > >>> Regards,
> > > > >>> Suresh
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Advanced conditional formatting

2009-08-28 Thread liuxin9...@gmail.com 

hi,your answer is very good.
When using the relative reference, the first cell in the row gets the
right answer.
However, when it happens in the next cell, the formula changes because
I am using the relative reference.

On Aug 28, 12:35 pm, Dilip Pandey  wrote:
> Hi Liuxin,
>
> This is because, when you use absolute reference ($ref$), conditional
> formatting logics on the entire row is checking if that particular reference
> is meeting the logics or not.  Moreover, when you apply that logic towards
> right direction to cover entire row, the logic still checks only that
> particular reference, which is still meeting up with the criteria defined
> and hence, entire row gets colored.
>
> For more details, refer to the attachement which I just forwarded to Suresh
> and "Group".
>
> Let me know in case of any queries.  Thanks
>
> --
> DILIP KUMAR PANDEY
>MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
> On 8/27/09, liuxin9...@gmail.com  wrote:
>
>
>
>
>
> > I have a question.
> > When I use the relative reference in the formula, there is only one
> > cell colored.
> > While if I use the absolute reference, the complete row is colored,
> > why?
>
> > On 8月27日, 下午10时53分, Dilip Pandey  wrote:
> > > Dear Suresh,  I think you forgot to attach the file.  Please re-attach
> > and
> > > send.  Thanks.
> > > --
> > > DILIP KUMAR PANDEY
> > >   MBA-HR,B COM(Hons.),BCA
> > > Mobile: +91 9810929744
> > > dilipan...@gmail.com
> > > dilipan...@yahoo.com
> > > New Delhi - 110062
>
> > > On Thu, Aug 27, 2009 at 8:17 PM, suresh k 
> > wrote:
> > > > Hi Dilip,
>
> > > > Can you check this attachment. Its having three options "TRUE", "FALSE"
> > and
> > > > "Not available. In this case is it possible to highlight entire rows in
> > > > different color based on the result.
>
> > > > On Thu, Aug 27, 2009 at 8:03 PM, Dilip Pandey  > >wrote:
>
> > > >> Hi Suresh.
>
> > > >> Attached file has the scenario and the explanation for your
> > query.  Thanks
>
> > > >> --
> > > >> DILIP KUMAR PANDEY
> > > >>   MBA-HR,B COM(Hons.),BCA
> > > >> Mobile: +91 9810929744
> > > >> dilipan...@gmail.com
> > > >> dilipan...@yahoo.com
> > > >> New Delhi - 110062
>
> > > >> On Thu, Aug 27, 2009 at 4:51 PM, suresh k 
> > wrote:
>
> > > >>> Hi Guyz,
>
> > > >>> Whenever we use conditional formatting it will be applied for current
> > > >>> cell only.
>
> > > >>> Is there anyway that if the condition is true the entire row should
> > be
> > > >>> colored???
>
> > > >>> Regards,
> > > >>> Suresh

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: compare two list

2009-08-28 Thread Dilip Pandey 
Hi Suresh,  When I looked at the scenario provided in the query... that was
highlighting the data which was not present in another column and vice
versa.  Same is incorporated in the solution provided by me.  Please note
that either the data is there in another column and the data is not there in
another column and only one condition can be true at a time and hence,
conditional formatting will work accordingly. Thanks

-- 
DILIP KUMAR PANDEY
  MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062


2009/8/28 suresh k 

> In this sheet, any data you enter in column C or E it will change the
> color,
> It should change the color only if the data is matching in the other
> column.
>
> Is there any way like that
>
>
> 2009/8/28 Dilip Pandey 
>
>> Hi Manoj,
>>
>> Apologies for delay.  Attached herewith the solution which you are looking
>> for.  Thanks
>>
>> --
>> DILIP KUMAR PANDEY
>>   MBA-HR,B COM(Hons.),BCA
>> Mobile: +91 9810929744
>> dilipan...@gmail.com
>> dilipan...@yahoo.com
>> New Delhi - 110062
>>
>>
>> 2009/8/28 Dilip Pandey 
>>
>>> Hi Manoj,
>>>
>>> Apologies for delay.  Attached herewith the solution which you are
>>> looking for.  Thanks
>>>
>>> --
>>> DILIP KUMAR PANDEY
>>>   MBA-HR,B COM(Hons.),BCA
>>> Mobile: +91 9810929744
>>> dilipan...@gmail.com
>>> dilipan...@yahoo.com
>>> New Delhi - 110062
>>>
>>>
>>> 2009/8/28 Manoj Kukrej 
>>>
>>>   Hi Dilip ,



 I want to compare two range ,-for finding the common & uncommon  (nos or
 text in it) presently I am using conditional formatting  using countif fn



 Pls tell me how I check it through other methods



 Regards



 Manoj



 *From:* excel-macros@googlegroups.com [mailto:
 excel-mac...@googlegroups.com] *On Behalf Of *Dilip Pandey
 *Sent:* Friday, August 28, 2009 10:05 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Re: Advanced conditional formatting



 Hi Liuxin,



 This is because, when you use absolute reference ($ref$), conditional
 formatting logics on the entire row is checking if that particular 
 reference
 is meeting the logics or not.  Moreover, when you apply that logic
 towards right direction to cover entire row, the logic still checks only
 that particular reference, which is still meeting up with the criteria
 defined and hence, entire row gets colored.



 For more details, refer to the attachement which I just forwarded to
 Suresh and "Group".



 Let me know in case of any queries.  Thanks



 --
 DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
 Mobile: +91 9810929744
 dilipan...@gmail.com
 dilipan...@yahoo.com
 New Delhi - 110062





 On 8/27/09, *liuxin9...@gmail.com*  wrote:


 I have a question.
 When I use the relative reference in the formula, there is only one
 cell colored.
 While if I use the absolute reference, the complete row is colored,
 why?

 On 8月27日, 下午10时53分, Dilip Pandey  wrote:
 > Dear Suresh,  I think you forgot to attach the file.  Please
 re-attach and
 > send.  Thanks.
 > --
 > DILIP KUMAR PANDEY
 >   MBA-HR,B COM(Hons.),BCA
 > Mobile: +91 9810929744
 > dilipan...@gmail.com
 > dilipan...@yahoo.com
 > New Delhi - 110062
 >
 >
 >
 > On Thu, Aug 27, 2009 at 8:17 PM, suresh k 
 wrote:
 > > Hi Dilip,
 >
 > > Can you check this attachment. Its having three options "TRUE",
 "FALSE" and
 > > "Not available. In this case is it possible to highlight entire rows
 in
 > > different color based on the result.
 >
 > > On Thu, Aug 27, 2009 at 8:03 PM, Dilip Pandey >>> >wrote:
 >
 > >> Hi Suresh.
 >
 > >> Attached file has the scenario and the explanation for your query.
   Thanks
 >
 > >> --
 > >> DILIP KUMAR PANDEY
 > >>   MBA-HR,B COM(Hons.),BCA
 > >> Mobile: +91 9810929744
 > >> dilipan...@gmail.com
 > >> dilipan...@yahoo.com
 > >> New Delhi - 110062
 >
 > >> On Thu, Aug 27, 2009 at 4:51 PM, suresh k 
 wrote:
 >
 > >>> Hi Guyz,
 >
 > >>> Whenever we use conditional formatting it will be applied for
 current
 > >>> cell only.
 >
 > >>> Is there anyway that if the condition is true the entire row
 should be
 > >>> colored???
 >
 > >>> Regards,
 > >>> Suresh
 >>> --
 This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
 solely for the use of the addressee(s). If you are not the intended
 recipient, please notify the sender by e-mail and delete the original
 message. Further, you are not to copy, disclose, or distribute this e-mail
 or its contents to any other person and any s

$$Excel-Macros$$ Re: Urgent - Unprotected sheet

2009-08-28 Thread Prashant Bhawar 
On Fri, Aug 28, 2009 at 8:28 PM, prashant bhawar wrote:

>
>
> On Fri, Aug 28, 2009 at 4:11 PM, amresh kumar wrote:
>
>> Hi My All Friend,
>>
>> I Forget password of excel file.can u any help in unprotected file.
>>
>> Regards
>> Amresh
>>
>> On Fri, Aug 28, 2009 at 2:31 PM, Mahesh  wrote:
>>
>>> thanx
>>>
>>>
>>> On Fri, Aug 28, 2009 at 2:20 PM, Sandeep  wrote:
>>>
  Hi Mahesh,
 Find the attached solution

 Regards
 Sandeep

  - Original Message -
  *From:* Mahesh 
 *To:* excel-macros@googlegroups.com
  *Sent:* Friday, August 28, 2009 12:07 PM
 *Subject:* $$Excel-Macros$$ Vlookup not working in 2007

   Dear Friends,

 I m facing this problem in Excel 2007.

 attached is the excel sheet, kindly help.

 --
 With Love,
 Mahesh Bisht


>>>
>>>
>>> --
>>> With Love,
>>> Mahesh Bisht
>>>
>>>
>>>
>>
>> >>
>> Hello my friend if u r using office 2003 or earlier then just download the
> following which unprotect ur sheet
>
> http://www.straxx.com/excel/password.html
>
>
> --
> Warm Regard
>
> Prashant Bhawar
>



-- 
Warm Regard

Prashant Bhawar

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ if statements to compare string

2009-08-28 Thread Mog Obahor 
Hello Team,

I have all the variables in the cells stored in an array format and I am
iterating through the entire value to detect where "Jan" is .
How do I do an If Statement check for this.
thanks

*Project Num* *Project Title* *Project Type* *Impl Date* *Jan* *Feb*
*Mar* *Apr* *May* *Jun* *Jul* *Aug*

-- 
**
Omoghene Obahor
www.obahor.com
Cell: 214-493-7403
Fax: 866-338-1397
"As a Man Thinks So is He"
**

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Urgent - Unprotected sheet

2009-08-28 Thread Harmeet Singh 
send the file

On Fri, Aug 28, 2009 at 4:11 PM, amresh kumar wrote:

> Hi My All Friend,
>
> I Forget password of excel file.can u any help in unprotected file.
>
> Regards
> Amresh
>
> On Fri, Aug 28, 2009 at 2:31 PM, Mahesh  wrote:
>
>> thanx
>>
>>
>> On Fri, Aug 28, 2009 at 2:20 PM, Sandeep  wrote:
>>
>>>  Hi Mahesh,
>>> Find the attached solution
>>>
>>> Regards
>>> Sandeep
>>>
>>>  - Original Message -
>>>  *From:* Mahesh 
>>> *To:* excel-macros@googlegroups.com
>>>  *Sent:* Friday, August 28, 2009 12:07 PM
>>> *Subject:* $$Excel-Macros$$ Vlookup not working in 2007
>>>
>>>   Dear Friends,
>>>
>>> I m facing this problem in Excel 2007.
>>>
>>> attached is the excel sheet, kindly help.
>>>
>>> --
>>> With Love,
>>> Mahesh Bisht
>>>
>>>
>>
>>
>> --
>> With Love,
>> Mahesh Bisht
>>
>>
>>
>
> >
>


-- 
Thanks & Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Advanced conditional formatting

2009-08-28 Thread Dhananjay Pinjan 
Pl. find attached excel sheet for query.

Thanks & Regards,
Dhananjay


On 8/28/09, Dilip Pandey  wrote:
>
> Dear Suresh,
>
> Attachment has been solved and re-attached.  Thanks.
>
> --
> DILIP KUMAR PANDEY
>MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
> On 8/27/09, suresh k  wrote:
>>
>> Sorry,
>> Now with attachment
>>
>> On Thu, Aug 27, 2009 at 8:23 PM, Dilip Pandey wrote:
>>
>>> Dear Suresh,  I think you forgot to attach the file.  Please re-attach
>>> and send.  Thanks.
>>> --
>>> DILIP KUMAR PANDEY
>>>   MBA-HR,B COM(Hons.),BCA
>>> Mobile: +91 9810929744
>>> dilipan...@gmail.com
>>> dilipan...@yahoo.com
>>> New Delhi - 110062
>>>
>>>
>>>   On Thu, Aug 27, 2009 at 8:17 PM, suresh k wrote:
>>>
 Hi Dilip,

 Can you check this attachment. Its having three options "TRUE", "FALSE"
 and "Not available. In this case is it possible to highlight entire rows in
 different color based on the result.



 On Thu, Aug 27, 2009 at 8:03 PM, Dilip Pandey wrote:

> Hi Suresh.
>
> Attached file has the scenario and the explanation for your query.
> Thanks
>
> --
> DILIP KUMAR PANDEY
>   MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
>
> On Thu, Aug 27, 2009 at 4:51 PM, suresh k wrote:
>
>> Hi Guyz,
>>
>> Whenever we use conditional formatting it will be applied for current
>> cell only.
>>
>> Is there anyway that if the condition is true the entire row should be
>> colored???
>>
>> Regards,
>> Suresh
>>
>>
>
>
>
>>>
>>>
>>
>>
>
> >
>
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Sample of example basic VBA application for office 2007.

2009-08-28 Thread Aligahk06 
Dear All,

Could anybody provide us a sample of basic example of VBA application of
Excel 2007 and word 2007.

The example is for novice user. This is for self demonostration.

Please assist?

Rgds,

Aligahk06

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Urgent - Unprotected sheet

2009-08-28 Thread amresh kumar 
Hi My All Friend,

I Forget password of excel file.can u any help in unprotected file.

Regards
Amresh

On Fri, Aug 28, 2009 at 2:31 PM, Mahesh  wrote:

> thanx
>
>
> On Fri, Aug 28, 2009 at 2:20 PM, Sandeep  wrote:
>
>>  Hi Mahesh,
>> Find the attached solution
>>
>> Regards
>> Sandeep
>>
>>  - Original Message -
>> *From:* Mahesh 
>> *To:* excel-macros@googlegroups.com
>>  *Sent:* Friday, August 28, 2009 12:07 PM
>> *Subject:* $$Excel-Macros$$ Vlookup not working in 2007
>>
>>   Dear Friends,
>>
>> I m facing this problem in Excel 2007.
>>
>> attached is the excel sheet, kindly help.
>>
>> --
>> With Love,
>> Mahesh Bisht
>>
>>
>
>
> --
> With Love,
> Mahesh Bisht
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Advanced conditional formatting

2009-08-28 Thread Dilip Pandey 
Hi Suresh... "The Brave Man"..!!
Thanks a ton..!!

-- 
DILIP KUMAR PANDEY
  MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062



2009/8/28 suresh k 

> Hi Dilip,
>
> Many thanks for your help.
> I tried without MID formula, even it is working.
>
> Regards,
> Suresh
>
> 2009/8/28 Dilip Pandey 
>
>  Hi Liuxin,
>>
>> This is because, when you use absolute reference ($ref$), conditional
>> formatting logics on the entire row is checking if that particular reference
>> is meeting the logics or not.  Moreover, when you apply that logic towards
>> right direction to cover entire row, the logic still checks only that
>> particular reference, which is still meeting up with the criteria defined
>> and hence, entire row gets colored.
>>
>> For more details, refer to the attachement which I just forwarded to
>> Suresh and "Group".
>>
>> Let me know in case of any queries.  Thanks
>>
>>
>> --
>> DILIP KUMAR PANDEY
>>MBA-HR,B COM(Hons.),BCA
>> Mobile: +91 9810929744
>> dilipan...@gmail.com
>> dilipan...@yahoo.com
>> New Delhi - 110062
>>
>>
>>
>> On 8/27/09, liuxin9...@gmail.com  wrote:
>>>
>>>
>>> I have a question.
>>> When I use the relative reference in the formula, there is only one
>>> cell colored.
>>> While if I use the absolute reference, the complete row is colored,
>>> why?
>>>
>>> On 8月27日, 下午10时53分, Dilip Pandey  wrote:
>>> > Dear Suresh,  I think you forgot to attach the file.  Please re-attach
>>> and
>>> > send.  Thanks.
>>> > --
>>> > DILIP KUMAR PANDEY
>>> >   MBA-HR,B COM(Hons.),BCA
>>> > Mobile: +91 9810929744
>>> > dilipan...@gmail.com
>>> > dilipan...@yahoo.com
>>> > New Delhi - 110062
>>> >
>>> >
>>> >
>>> > On Thu, Aug 27, 2009 at 8:17 PM, suresh k 
>>> wrote:
>>> > > Hi Dilip,
>>> >
>>> > > Can you check this attachment. Its having three options "TRUE",
>>> "FALSE" and
>>> > > "Not available. In this case is it possible to highlight entire rows
>>> in
>>> > > different color based on the result.
>>> >
>>> > > On Thu, Aug 27, 2009 at 8:03 PM, Dilip Pandey >> >wrote:
>>> >
>>> > >> Hi Suresh.
>>> >
>>> > >> Attached file has the scenario and the explanation for your
>>> query.  Thanks
>>> >
>>> > >> --
>>> > >> DILIP KUMAR PANDEY
>>> > >>   MBA-HR,B COM(Hons.),BCA
>>> > >> Mobile: +91 9810929744
>>> > >> dilipan...@gmail.com
>>> > >> dilipan...@yahoo.com
>>> > >> New Delhi - 110062
>>> >
>>> > >> On Thu, Aug 27, 2009 at 4:51 PM, suresh k 
>>> wrote:
>>> >
>>> > >>> Hi Guyz,
>>> >
>>> > >>> Whenever we use conditional formatting it will be applied for
>>> current
>>> > >>> cell only.
>>> >
>>> > >>> Is there anyway that if the condition is true the entire row should
>>> be
>>> > >>> colored???
>>> >
>>> > >>> Regards,
>>> > >>> Suresh
>>> >>>
>>>
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Need help on formula

2009-08-28 Thread vinod rao 
Hi All,

Thanks for all your support.
Regards,
Vinod

On Thu, Aug 27, 2009 at 11:13 PM, vivek agrawal
wrote:

> Hi
> As per what you want... my answers are in red with yellow background
>
> The best way for what you want is that sort the column and then apply the
> formula in red with yellow...
>
> Hope this helps
>
>  Thanks and Regards,
> Vivek Agrawal
> Skype ID - vivek.agrawal83
>
> GoogleMoonlight.com  - Saving energy-Save Earth
>
>
>
>
>   On Thu, Aug 27, 2009 at 7:15 PM, vinod rao wrote:
>
>>
>> Hello Vivek,
>>
>> Still it didn't  work. if the number is repeating it should ranks the same
>> so it is right but the next largest number sequence is not correct. I have
>> sorted data to simplyfy my doubt.
>> For more details i have attached the file. now i believe you can
>> understand my problem much better. Thanks you in advance for your support.
>>
>> Awaiting your reply.
>>
>>
>> On Thu, Aug 27, 2009 at 9:38 AM, vivek agrawal > > wrote:
>>
>>> Hi Vinod
>>>
>>> Attached is the file with the solution you want
>>>
>>> Thanks and Regards,
>>> Vivek Agrawal
>>> Skype ID - vivek.agrawal83
>>>
>>> GoogleMoonlight.com  - Saving energy-Save Earth
>>>
>>>
>>>
>>>
>>>   On Wed, Aug 26, 2009 at 6:14 PM, vinod rao wrote:
>>>
 Hello Expert Team,

 See the correct ranking that i want. I have attached file.

 Hope i have clarified my question.
 Regards,

   On Wed, Aug 26, 2009 at 5:04 PM, vinod rao wrote:

> Hello Vivek,
>
> See my file, I am unable to still trace right result.
>
> Row 599 has 15.2 value and it should result as 1 but it is showing 34.
> That is one of the example i am looking for.
>
> Regards,
> Vinod
>
>   On Wed, Aug 26, 2009 at 4:37 PM, vinod rao wrote:
>
>> This will help.Thank you
>>
>> can you put formula without using Fcolumn, I want to findout the data
>> from E only because my workshee is restricted to add one more line.? any
>> suggestion on this plz.
>>   On Wed, Aug 26, 2009 at 4:07 PM, vivek agrawal <
>> vivek.agrawa...@gmail.com> wrote:
>>
>>> Hope This Helps
>>>
>>>
>>> Thanks and Regards,
>>> Vivek Agrawal
>>> Skype ID - vivek.agrawal83
>>>
>>> GoogleMoonlight.com  - Saving energy-Save Earth
>>>
>>>
>>>
>>>
>>>   On Wed, Aug 26, 2009 at 3:47 PM, vinod rao 
>>> wrote:
>>>
 Hello Vivek,

 I could not get the right answer. I need like

  Example

 Amount Rank
 200 3
 100 2
 -50NA
 10  1
 -5  NA
 3004

 Can you plz get it done in the new excel file?. Thanks Advance my
 friend.

 On Wed, Aug 26, 2009 at 1:09 PM, vivek agrawal <
 vivek.agrawa...@gmail.com> wrote:

> The third argument of the RANK function specifies the ranking
> order
> Blank or "0" means ascending order
> any other positive number or "1" means the other way round
>
> Thanks and Regards,
> Vivek Agrawal
> Skype ID - vivek.agrawal83
>
> GoogleMoonlight.com  - Saving energy-Save Earth
>
>
>
>
>   On Wed, Aug 26, 2009 at 11:04 AM, vinod rao <
> vinod.ma...@gmail.com> wrote:
>
>> Thank you Very much.
>>
>> Can we have in reverse order, I mean low to high.?
>> Advance thanks to all members.
>>
>> Example
>>
>>  Amount Rank
>> 200 4
>> 1002
>> -50NA
>> 10 1
>> -5  NA
>> 300  4
>>   On Wed, Aug 26, 2009 at 9:48 AM, vivek agrawal <
>> vivek.agrawa...@gmail.com> wrote:
>>
>>> Hi
>>>
>>> attached is the solution to your query
>>>
>>> Hope it helps
>>>
>>>
>>>
>>> Thanks and Regards,
>>> Vivek Agrawal
>>> Skype ID - vivek.agrawal83
>>>
>>> GoogleMoonlight.com  - Saving energy-Save Earth
>>>
>>>
>>>
>>>
>>> On Tue, Aug 25, 2009 at 9:52 PM, vinod rao <
>>> vinod.ma...@gmail.com> wrote:
>>>
 Hello Team,

 How do i rank only positive numbers. Plz help me on formula.

 Example

 Amount Rank
 200 2
 100 3
 -50NA
 10  4
 -5  NA
 3001




>>>
>>>
>>
>>
>>
>
>



>>>
>>>

$$Excel-Macros$$ Re: Hi My All Friends Urgent

2009-08-28 Thread Aindril De 
Hi Amresh,

This can be achieved doing the following steps:

1) Select the entire sheet.
2) Right Click on the selected area and select Format Cells.
3) In the format cells dialog box choose the Protection Tab.
4) Click on the Locked and uncheck it.
5) Click OK.
6) Now select the cell that you want to protect.
7) You Can press the Ctrl key and click on the cells if you want to protect
multiple cells.
8) Right click on any of the selected cells and choose Format cells.
9) Choose Format Cells.
10) In the Protection Tab, check the Locked.
11) At this stage the selected cells are locked.
12) Now Protect the sheet using a password (You can choose the relevant
protection options or keep the defaults as it is).
13) This will ensure that the Locked Cells cannot be modified.

Hope this helps. Please let me know if you need any further help.
Regards,
Andy
On Fri, Aug 28, 2009 at 4:10 PM, amresh kumar wrote:

> Hi My All Friends,
> I want Protect select cell in a Sheet.Can u Help Me in Excel,
>
> Thanks,
> Amresh
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: compare two list

2009-08-28 Thread Harmeet Singh 
*See attached file...*

On Fri, Aug 28, 2009 at 3:08 PM, Manoj Kukrej wrote:

>  Hi All ,
>
>
>
> similar Items are @ different rows just like in attached file
>
>
>
> I want to compare two range ,-for finding the common & uncommon  (nos or
> text in it) presently I am using conditional formatting  using countif fn
>
>
>
> Pls tell me how I check it through other methods
>
>
>
> Regards
>
>
>
> Manoj
>
>
>
> --
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
> solely for the use of the addressee(s). If you are not the intended
> recipient, please notify the sender by e-mail and delete the original
> message. Further, you are not to copy, disclose, or distribute this e-mail
> or its contents to any other person and any such actions that are unlawful.
> This e-mail may contain viruses. Ocimum Biosolutions has taken every
> reasonable precaution to minimize this risk, but is not liable for any
> damage you may sustain as a result of any virus in this e-mail. You should
> carry out your own virus checks before opening the e-mail or attachment.
>
> >
>
>


-- 
Thanks & Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Book2.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Hi My All Friends Urgent

2009-08-28 Thread amresh kumar 
Hi My All Friends,
I want Protect select cell in a Sheet.Can u Help Me in Excel,

Thanks,
Amresh

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ compare two list

2009-08-28 Thread Manoj Kukrej 
Hi All ,

similar Items are @ different rows just like in attached file

I want to compare two range ,-for finding the common & uncommon  (nos or text 
in it) presently I am using conditional formatting  using countif fn

Pls tell me how I check it through other methods

Regards

Manoj



This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
for the use of the addressee(s). If you are not the intended recipient, please 
notify the sender by e-mail and delete the original message. Further, you are 
not to copy, disclose, or distribute this e-mail or its contents to any other 
person and any such actions that are unlawful. This e-mail may contain viruses. 
Ocimum Biosolutions has taken every reasonable precaution to minimize this 
risk, but is not liable for any damage you may sustain as a result of any virus 
in this e-mail. You should carry out your own virus checks before opening the 
e-mail or attachment.

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



compare.xls
Description: compare.xls

$$Excel-Macros$$ Re: compare two list

2009-08-28 Thread Harmeet Singh 
*Check attached file.*

2009/8/28 Sandeep 

>  Hi Manoj,
> Find the attached solution
>
> Regards
> Sandeep
>
> - Original Message -
> *From:* Manoj Kukrej 
> *To:* dilipan...@gmail.com
> *Cc:* excel-macros@googlegroups.com
> *Sent:* Friday, August 28, 2009 12:55 PM
> *Subject:* $$Excel-Macros$$ compare two list
>
>  Hi Dilip ,
>
>
>
> I want to compare two range ,-for finding the common & uncommon  (nos or
> text in it) presently I am using conditional formatting  using countif fn
>
>
>
> Pls tell me how I check it through other methods
>
>
>
> Regards
>
>
>
> Manoj
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *Dilip Pandey
> *Sent:* Friday, August 28, 2009 10:05 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re: Advanced conditional formatting
>
>
>
> Hi Liuxin,
>
>
>
> This is because, when you use absolute reference ($ref$), conditional
> formatting logics on the entire row is checking if that particular reference
> is meeting the logics or not.  Moreover, when you apply that logic towards
> right direction to cover entire row, the logic still checks only that
> particular reference, which is still meeting up with the criteria defined
> and hence, entire row gets colored.
>
>
>
> For more details, refer to the attachement which I just forwarded to Suresh
> and "Group".
>
>
>
> Let me know in case of any queries.  Thanks
>
>
>
> --
> DILIP KUMAR PANDEY
>MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
>
>
>
> On 8/27/09, *liuxin9...@gmail.com*  wrote:
>
>
> I have a question.
> When I use the relative reference in the formula, there is only one
> cell colored.
> While if I use the absolute reference, the complete row is colored,
> why?
>
> On 8月27日, 下午10时53分, Dilip Pandey  wrote:
> > Dear Suresh,  I think you forgot to attach the file.  Please re-attach
> and
> > send.  Thanks.
> > --
> > DILIP KUMAR PANDEY
> >   MBA-HR,B COM(Hons.),BCA
> > Mobile: +91 9810929744
> > dilipan...@gmail.com
> > dilipan...@yahoo.com
> > New Delhi - 110062
> >
> >
> >
> > On Thu, Aug 27, 2009 at 8:17 PM, suresh k 
> wrote:
> > > Hi Dilip,
> >
> > > Can you check this attachment. Its having three options "TRUE", "FALSE"
> and
> > > "Not available. In this case is it possible to highlight entire rows in
> > > different color based on the result.
> >
> > > On Thu, Aug 27, 2009 at 8:03 PM, Dilip Pandey  >wrote:
> >
> > >> Hi Suresh.
> >
> > >> Attached file has the scenario and the explanation for your query.
> Thanks
> >
> > >> --
> > >> DILIP KUMAR PANDEY
> > >>   MBA-HR,B COM(Hons.),BCA
> > >> Mobile: +91 9810929744
> > >> dilipan...@gmail.com
> > >> dilipan...@yahoo.com
> > >> New Delhi - 110062
> >
> > >> On Thu, Aug 27, 2009 at 4:51 PM, suresh k 
> wrote:
> >
> > >>> Hi Guyz,
> >
> > >>> Whenever we use conditional formatting it will be applied for current
> > >>> cell only.
> >
> > >>> Is there anyway that if the condition is true the entire row should
> be
> > >>> colored???
> >
> > >>> Regards,
> > >>> Suresh
> 
> --
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
> solely for the use of the addressee(s). If you are not the intended
> recipient, please notify the sender by e-mail and delete the original
> message. Further, you are not to copy, disclose, or distribute this e-mail
> or its contents to any other person and any such actions that are unlawful.
> This e-mail may contain viruses. Ocimum Biosolutions has taken every
> reasonable precaution to minimize this risk, but is not liable for any
> damage you may sustain as a result of any virus in this e-mail. You should
> carry out your own virus checks before opening the e-mail or attachment.
> >
>


-- 
Thanks & Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Book2.xls
Description: MS-Ex

$$Excel-Macros$$ Re: Vlookup not working in 2007

2009-08-28 Thread Sathish Jalendran 
Hi,

 

Check the attached file 

1 u have to freeze cells in the formula 

2 you have to convert to numbers before applying the formula

 

Regards

Sathish Jalendran

 

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Mahesh
Sent: 28 August 2009 PM 12:08
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Vlookup not working in 2007

 

Dear Friends,

 

I m facing this problem in Excel 2007.

 

attached is the excel sheet, kindly help.



-- 
With Love,
Mahesh Bisht



The information contained in this electronic message and any attachments to 
this message are intended for the exclusive 
use of the addressee(s) and may contain proprietary, confidential or privileged 
information. If you are not the intended
 recipient, you should not disseminate, distribute or copy this e-mail. Please 
notify the sender immediately and destroy
 all copies of this message and any attachments contained in it.


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Copy of Test.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Re: Vlookup not working in 2007

2009-08-28 Thread Mahesh 
thanx

On Fri, Aug 28, 2009 at 2:20 PM, Sandeep  wrote:

>  Hi Mahesh,
> Find the attached solution
>
> Regards
> Sandeep
>
>  - Original Message -
> *From:* Mahesh 
> *To:* excel-macros@googlegroups.com
>  *Sent:* Friday, August 28, 2009 12:07 PM
> *Subject:* $$Excel-Macros$$ Vlookup not working in 2007
>
>   Dear Friends,
>
> I m facing this problem in Excel 2007.
>
> attached is the excel sheet, kindly help.
>
> --
> With Love,
> Mahesh Bisht
>
> >
>


-- 
With Love,
Mahesh Bisht

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: compare two list

2009-08-28 Thread Sandeep 
Hi Manoj,
Find the attached solution

Regards
Sandeep
  - Original Message - 
  From: Manoj Kukrej 
  To: dilipan...@gmail.com 
  Cc: excel-macros@googlegroups.com 
  Sent: Friday, August 28, 2009 12:55 PM
  Subject: $$Excel-Macros$$ compare two list


  Hi Dilip ,

   

  I want to compare two range ,-for finding the common & uncommon  (nos or text 
in it) presently I am using conditional formatting  using countif fn

   

  Pls tell me how I check it through other methods

   

  Regards

   

  Manoj

   

  From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On 
Behalf Of Dilip Pandey
  Sent: Friday, August 28, 2009 10:05 AM
  To: excel-macros@googlegroups.com
  Subject: $$Excel-Macros$$ Re: Advanced conditional formatting

   

  Hi Liuxin,

   

  This is because, when you use absolute reference ($ref$), conditional 
formatting logics on the entire row is checking if that particular reference is 
meeting the logics or not.  Moreover, when you apply that logic towards right 
direction to cover entire row, the logic still checks only that particular 
reference, which is still meeting up with the criteria defined and hence, 
entire row gets colored.

   

  For more details, refer to the attachement which I just forwarded to Suresh 
and "Group". 

   

  Let me know in case of any queries.  Thanks



  -- 
  DILIP KUMAR PANDEY  
 MBA-HR,B COM(Hons.),BCA
  Mobile: +91 9810929744
  dilipan...@gmail.com
  dilipan...@yahoo.com
  New Delhi - 110062 



   

  On 8/27/09, liuxin9...@gmail.com  wrote: 


  I have a question.
  When I use the relative reference in the formula, there is only one
  cell colored.
  While if I use the absolute reference, the complete row is colored,
  why?

  On 8月27日, 下午10时53分, Dilip Pandey  wrote:
  > Dear Suresh,  I think you forgot to attach the file.  Please re-attach and
  > send.  Thanks.
  > --
  > DILIP KUMAR PANDEY
  >   MBA-HR,B COM(Hons.),BCA
  > Mobile: +91 9810929744
  > dilipan...@gmail.com
  > dilipan...@yahoo.com
  > New Delhi - 110062
  >
  >
  >
  > On Thu, Aug 27, 2009 at 8:17 PM, suresh k  wrote:
  > > Hi Dilip,
  >
  > > Can you check this attachment. Its having three options "TRUE", "FALSE" 
and
  > > "Not available. In this case is it possible to highlight entire rows in
  > > different color based on the result.
  >
  > > On Thu, Aug 27, 2009 at 8:03 PM, Dilip Pandey wrote:
  >
  > >> Hi Suresh.
  >
  > >> Attached file has the scenario and the explanation for your query.  
Thanks
  >
  > >> --
  > >> DILIP KUMAR PANDEY
  > >>   MBA-HR,B COM(Hons.),BCA
  > >> Mobile: +91 9810929744
  > >> dilipan...@gmail.com
  > >> dilipan...@yahoo.com
  > >> New Delhi - 110062
  >
  > >> On Thu, Aug 27, 2009 at 4:51 PM, suresh k  wrote:
  >
  > >>> Hi Guyz,
  >
  > >>> Whenever we use conditional formatting it will be applied for current
  > >>> cell only.
  >
  > >>> Is there anyway that if the condition is true the entire row should be
  > >>> colored???
  >
  > >>> Regards,
  > >>> Suresh
  http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



compare.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ compare two list

2009-08-28 Thread Manoj Kukrej 
Hi Dilip ,

I want to compare two range ,-for finding the common & uncommon  (nos or text 
in it) presently I am using conditional formatting  using countif fn

Pls tell me how I check it through other methods

Regards

Manoj

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On 
Behalf Of Dilip Pandey
Sent: Friday, August 28, 2009 10:05 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Advanced conditional formatting

Hi Liuxin,

This is because, when you use absolute reference ($ref$), conditional 
formatting logics on the entire row is checking if that particular reference is 
meeting the logics or not.  Moreover, when you apply that logic towards right 
direction to cover entire row, the logic still checks only that particular 
reference, which is still meeting up with the criteria defined and hence, 
entire row gets colored.

For more details, refer to the attachement which I just forwarded to Suresh and 
"Group".

Let me know in case of any queries.  Thanks


--
DILIP KUMAR PANDEY
   MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062



On 8/27/09, liuxin9...@gmail.com 
mailto:liuxin9...@gmail.com>> wrote:

I have a question.
When I use the relative reference in the formula, there is only one
cell colored.
While if I use the absolute reference, the complete row is colored,
why?

On 8月27日, 下午10时53分, Dilip Pandey 
mailto:dilipan...@gmail.com>> wrote:
> Dear Suresh,  I think you forgot to attach the file.  Please re-attach and
> send.  Thanks.
> --
> DILIP KUMAR PANDEY
>   MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
>
> On Thu, Aug 27, 2009 at 8:17 PM, suresh k 
> mailto:brave.sur...@gmail.com>> wrote:
> > Hi Dilip,
>
> > Can you check this attachment. Its having three options "TRUE", "FALSE" and
> > "Not available. In this case is it possible to highlight entire rows in
> > different color based on the result.
>
> > On Thu, Aug 27, 2009 at 8:03 PM, Dilip Pandey 
> > mailto:dilipan...@gmail.com>>wrote:
>
> >> Hi Suresh.
>
> >> Attached file has the scenario and the explanation for your query.  Thanks
>
> >> --
> >> DILIP KUMAR PANDEY
> >>   MBA-HR,B COM(Hons.),BCA
> >> Mobile: +91 9810929744
> >> dilipan...@gmail.com
> >> dilipan...@yahoo.com
> >> New Delhi - 110062
>
> >> On Thu, Aug 27, 2009 at 4:51 PM, suresh k 
> >> mailto:brave.sur...@gmail.com>> wrote:
>
> >>> Hi Guyz,
>
> >>> Whenever we use conditional formatting it will be applied for current
> >>> cell only.
>
> >>> Is there anyway that if the condition is true the entire row should be
> >>> colored???
>
> >>> Regards,
> >>> Suresh
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



compare.xls
Description: compare.xls

$$Excel-Macros$$ Vlookup not working in 2007

2009-08-28 Thread Mahesh 
Dear Friends,

I m facing this problem in Excel 2007.

attached is the excel sheet, kindly help.

-- 
With Love,
Mahesh Bisht

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Test.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Re: Atlast got it

2009-08-28 Thread amresh kumar 
Please solve the query

On Fri, Aug 28, 2009 at 9:57 AM, amresh kumar wrote:

>
>
> -- Forwarded message --
> From: Dilip Pandey 
> Date: Aug 27, 2009 4:46 PM
> Subject: $$Excel-Macros$$ Re: Atlast got it
> To: excel-macros@googlegroups.com
> Cc: vidyut more 
>
> Thanks Vidyut..!!
> Your second query is also solved and the spreadsheet containing solution is
> attached herewith.  Thanks
>
> --
> DILIP KUMAR PANDEY
>   MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
> On Thu, Aug 27, 2009 at 12:03 PM, vidyut more wrote:
>
>> Hi Dilip
>> at last i got how to paly sumproduct formula. thanks very much. i have
>> new query for you. I enter  party biil in excel . iwant to restrict
>> duplicate Bill entry. one way i know is countif formula in data
>> validation. but it wont distingwish between party. help please
>>
>
>
>
>
> >
>
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---