$$Excel-Macros$$ Get name of the sheet using formula

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,31) :) Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), F

$$Excel-Macros$$ Re: How to remove an add in

Hi Subu, Press Alt + T + I Press Alt + B select the addin and press delete Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/9/09, Subu wrote: > > > Hi Folks > > I have used an add-in on one of

$$Excel-Macros$$ Re: Problems with Conditional deletion of rows

Hi Thomas, 'Try below code:- Sub del() Cells(1, 1).Select Selection.EntireRow.Select For i = 1 To WorksheetFunction.CountA(Range("a:a")) + 15 If WorksheetFunction.CountIf(Selection, "#") > 0 Then Selection.EntireRow.Delete Else Selection.Offset(1, 0).Select End If Next End Sub Tested File contain

$$Excel-Macros$$ Re: How to Show Count of Zero in Pivot Table

Mr. Daniel I have tried to apply Pivot Table on the Base Data but could not succeed as the pop up message showing "Data source reference is not valid". Please help Rajeev On Sun, Sep 20, 2009 at 1:25 PM, Daniel wrote: > Sorry Here it is. > > > -Original Message- > > From: excel-macros@goo

$$Excel-Macros$$ Re: How to Show Count of Zero in Pivot Table

Have you a problem with my file ? Please send file. Daniel From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Rajeev Nandan Sent: dimanche 20 septembre 2009 13:30 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: How to Show Count of Zero i

$$Excel-Macros$$ Re: Compare 4 columns in excel spreadsheet

Hi The scenario given by you is there in the attached workbook along with the solution. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/10/09, fishbonez wrote: > > > i would like to know how can

$$Excel-Macros$$ Defining ranges based on moving headers

Hi All: First off this is a terrific user group and is required reading for my team! Here is my question: I receive a table that has the headers A1: Name B1: Address1 C1: State D1: Zip The next time, I receive the table with headers may say: A1: Name B1: Address1 C1: Address2 D1: State E1: Zip

$$Excel-Macros$$ Re: help plz

Hi Ashish, Your query has been solved and 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 9/11/09, ashish koul wrote: > > hi > > i wanted a formula in sheet 2 which will tell me

$$Excel-Macros$$ Re: Nested Formula

Hi Jitheesh, Actually a good query and reasonable too. Attached workbook has been solved per your requirements. Enjoy..!! Suggestion:- Do not merge the cells, just for the shake of looks. Alternatively keep the data in one cell and do a format boarder, justify etc to keep the reach and area fil

$$Excel-Macros$$ Re: Vlookup and If formula

Dear Jitheesh, Answered this one at 09:39 PM IST. Check that and let me know if you have any questions. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/15/09, Jitheesh Vazhapully <7jit...@gmail.com

$$Excel-Macros$$ Re: Defining ranges based on moving headers

Hi, You can set the range address to anoter formula, using offset for instance: =OFFSET('Address'!R1C1,0,match("Zip",'Address'!R1,0)-1) that will pont to zip column whenever it is... regards 2009/9/20 MD18358 > > Hi All: > > First off this is a terrific user group and is required reading for

$$Excel-Macros$$ urgent help required in excel sheet

Hi i have attached 1 file, in this file i want to fill the frequency column i hv tried count formula but it doesnt work may be the way i m using the formula is rong plz help me Regards Ruchi --~--~-~--~~~---~--~~ -