$$Excel-Macros$$ Re: help with Vloopup function

Test On Thu, Aug 27, 2009 at 1:17 PM, vivek agrawal vivek.agrawa...@gmail.comwrote: it prompts because it needs the SAP Records worksheet to be opened when it executes the statement... excel checks all the open workbooks and tries to find the workbook referenced hence you need to keep

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

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 brave.sur...@gmail.com wrote: Sorry, Now with attachment On Thu, Aug

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

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

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

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

*Check attached file.* 2009/8/28 Sandeep sandymau...@gmail.com Hi Manoj, Find the attached solution Regards Sandeep - Original Message - *From:* Manoj Kukrej manoj...@ocimumbio.com *To:* dilipan...@gmail.com *Cc:* excel-macros@googlegroups.com *Sent:* Friday, August 28,

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

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

*See attached file...* On Fri, Aug 28, 2009 at 3:08 PM, Manoj Kukrej manoj...@ocimumbio.comwrote: 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

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

$$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 vivek.agrawa...@gmail.comwrote: 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

$$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 brave.sur...@gmail.com Hi Dilip, Many thanks for your help. I tried without MID formula,

$$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 mahender.bi...@gmail.com wrote: thanx On Fri, Aug 28, 2009 at 2:20 PM, Sandeep sandymau...@gmail.com wrote: Hi Mahesh, Find the attached solution

$$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$$ Re: Advanced conditional formatting

Pl. find attached excel sheet for query. Thanks Regards, Dhananjay On 8/28/09, Dilip Pandey dilipan...@gmail.com 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

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

On Fri, Aug 28, 2009 at 8:28 PM, prashant bhawar bhawar.prs...@gmail.comwrote: On Fri, Aug 28, 2009 at 4:11 PM, amresh kumar amreshkushw...@gmail.comwrote: 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

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

$$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 dilipan...@gmail.com wrote: Hi Liuxin,

$$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 liuxin9...@gmail.com wrote: hi,your answer is very good.

$$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 vidyutm...@gmail.com wrote: Hi, Dilip. Thanks Again.