$$Excel-Macros$$ NEED HELP on multiple vlookup

Dear All, I need your help. Kindly find the attached data sheet, query & the solution which i need is explained in it. Please help me on the issue since i have to invest a lot of time in solving it. Thanks in advance. -- -- Thanks & Regards, Madhur Baharani OSS Kolkata Mob: 91-98744

$$Excel-Macros$$ need array formula

Hi, How to use {=TABLE(,K11)} this type of function. -- Thanks, Gyanesh Jain, BE, MBA (Finance) +91 98868 68488 Please Save a tree...please don't print this e-mail unless you really need to --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ Re: Excel multiple formula in a cell

Raj: Only one formula, to the best of my knowledge, but that formula may have many "nested" functions. Mike Daniels On Sep 2, 8:06 am, Raj Kumar wrote: > hi, > > i am your new friend and i have some doubt in Excel so i want to ask a > question to you The question is:- > > How many formulas can

$$Excel-Macros$$ Need help for Production

Dear Brothers & Sisters, I am satiq now I am learning Excel .. That too intresting.. Then could I know about How can I protect my worksheet with hiding formula?.. Satiq Kuwait --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ Re: How i can arrange data in Random manner

Hi Uma, Attached file has been revised as per your requirements. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/1/09, Umakant Hale wrote: > > Dear friends, > > but in output i require same value

$$Excel-Macros$$ Re: excel macros -non numeric value

*see attached file* On Wed, Sep 2, 2009 at 1:37 PM, ymusafi wrote: > > Hi All > I want to create a macro that is doing somthing if the cell value has > non numeric value > meaning: > if cell.value=???then > I just need to know what to put instead of the question marks > Thanks! > > > > -- Th

$$Excel-Macros$$ Run function from different workbook

Hi, I'm running a VBA script from a 'dummy' excel file to convert a txt file into a csv with a specific format. >From the 'dummy' excel several operations are performed as, open txt, add week numbers, create pivot table etc. All operations are performed in the openned txt. One essential thing is

RE: FW: $$Excel-Macros$$ Help Please

Dear Dilip, Tried that option but not able to get exact required output , file attached after a try . please advise & also if there any formula please send. Regards, Prashant From: Dilip Pandey [mailto:dilipan...@gmail.com] Sent: Wednesday, September 02, 2009 5:38 PM To: prashant

Re: FW: $$Excel-Macros$$ Help Please

Hi Prashant, I am not able to find any attachment in the email sent by you. Please re-attach the workbook with the result which you required as a scenario. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062

$$Excel-Macros$$ Custom Function ...

I've put this function into my Excel file, in the VBA section. I've put it in the Personal.xls Module 1. The worksheet itself. A new Module within the workbook. I've put it everywhere but it doesn't work. I cribbed it from the internet and it's meant to bring back the colour / color value of the

$$Excel-Macros$$ Help in print menu

Dear group member I have word or excel file containing 15 pages in that i want 1 to 7 pages in Portrait & 8 page as Landscape & again 9 to 15 pages as Portrait. I want each pages of word file with differnt page setup especially margins (eg. page no.1 top margin 1inch, page no.3 top margin 1.5 inc

$$Excel-Macros$$ Excel multiple formula in a cell

hi, i am your new friend and i have some doubt in Excel so i want to ask a question to you The question is:- How many formulas can be applied in a particular cell at a time? Thanks a lot Raj Bharti --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Re: excel macros -non numeric value

ymusafi, The following code checks to see whether the cell's contents is numeric or not: Public Function Test(cell As Range) If IsNumeric(cell.Value) Then Debug.Print "Numeric" Else Debug.Print "Not numeric" End If End Function Try it in the Immediate Window by typin

$$Excel-Macros$$ Disable 'Select Multiple Items' and '(All)' on PivotTable Report Filter

Greetings I would like to disable the 'Select Multiple Items' and '(All)' features from a PivotTable Report Filter (Page items). I do not know how to do it. I have data for multiple years that I would like to be able to see using the filter, but it makes no sense to add data together from diff

Re: FW: $$Excel-Macros$$ Help Please

Hi Prashant, You can use copy - paste special - transpose option and this will be taken care off in seconds. If your amount is going to change, then you can use formulation. let me know if you need this formulation. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744

$$Excel-Macros$$ Re: Vlookup Value

Hi Dilip, My requirement is, I want to Vlookup and the value returned is based on M or D. Example Vlookup of table value "A" (Column B) and value "D" (Column C) the value required as result is 26. But i will get answer as 25. Please help me to get it. Regards, Ashwin On Sep 2, 1:35 pm, Dilip Pa

$$Excel-Macros$$ Re: There is one think Plz Repply Fast

yes it possible Go On right click on chart sheet then go location and select go objective and press enter On Wed, Sep 2, 2009 at 12:14 PM, anil panchal wrote: > Hi Frnd, > > suppose maine pivot table banaya sheet 2 me ab chahta hu ki pivot chart bhi > bane sheet 2 me hi na ki sheet 3 me is it p

$$Excel-Macros$$ Re: Thanks a lot

Hey Vidyut... The electrifying man... 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 Wed, Sep 2, 2009 at 2:22 PM, vidyut more wrote: > Hi > Dilip Thanks

$$Excel-Macros$$ Re: There is one think Plz Repply Fast

You are welcome ji..!! Best regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Sep 2, 2009 at 2:13 PM, anil panchal wrote: > > Dear Sir jee > > Thanks, \ *"Dhanyawad" Jee* > > Anil Kumar > > On

$$Excel-Macros$$ Re: Vlookup Value

Thanks Umesh...!! Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Sep 2, 2009 at 1:43 PM, Umesh Gupta 3 wrote: > IT IS REALLY GOOD > > THANKS > > - Original Message - > *From:* D

$$Excel-Macros$$ Re: Vlookup Value

IT IS REALLY GOOD THANKS - Original Message - From: Dilip Pandey To: excel-macros@googlegroups.com Sent: 02 September, 2009 10:53 AM Subject: $$Excel-Macros$$ Re: Vlookup Value Hi Ashwin, I believe you need multiple values based on single criteria across the data rang

$$Excel-Macros$$ excel macros -non numeric value

Hi All I want to create a macro that is doing somthing if the cell value has non numeric value meaning: if cell.value=???then I just need to know what to put instead of the question marks Thanks! --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ VBA: how to repeat a code and count not empty rows

Hello, I would appreciate if you could help me. I have a file with rows where some of them need to be deleted when column E is empty. However, there are several blocks of not empty rows. Therefore, I need the code to be repeated until column A is empty. row = 3 column = 5 number_of_notempty_rows

$$Excel-Macros$$ Re: Ignore my previous mail

Hi Moksh, Check out the following links:- http://www.cpearson.com/excel/Classes.aspx http://www.developersdex.com/gurus/articles/636.asp http://www.mrexcel.com/archive/VBA/29829.html Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@y

$$Excel-Macros$$ There is one think Plz Repply Fast

Hi Frnd, suppose maine pivot table banaya sheet 2 me ab chahta hu ki pivot chart bhi bane sheet 2 me hi na ki sheet 3 me is it possible or not? Thanks & Regards Anil Kumar 9278256426 --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: Help on PC No Formula

Hi Vidyut, File is corrected and re-formulated as per your requirements. Same is attached with this email. 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 Wed, Sep 2, 2009 at 11:27 AM