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

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

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

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 relat

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

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, wh

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

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 a

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

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: >> >>> t

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

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

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

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 wro

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

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...@ya

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

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 --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Urgent - Unprotected sheet

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 >> >>

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

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 workin

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

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...

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

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

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

*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 formatt

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

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

$$Excel-Macros$$ compare two list

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 __

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

*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

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

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$$ Re: Vlookup not working in 2007

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 w

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

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

$$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.co

$$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 --~--~-~--~~~---~--~~ -- Some important links for excel user

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

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..!! >