Re: $$Excel-Macros$$ Extracting Numbers from the Text

Hi Selva, Step 1: Separte the numbers using Text to column using "Space" as delimiter Step 2: Select Edit\Go to\ and click special and select constants and unselct the check box Numbers below the formulas options Step 3: Delete the selected cells You have got only the numbers, but in different

Re: $$Excel-Macros$$ Nesting of if.....

Hi Dave, Thanx a lot... It really solve my problem... simply GR8 On Tue, Dec 22, 2009 at 10:41 AM, Dave Bonallack wrote: > Hi, > You can use as many IF's as you like by using the & symbol. > IF(Condition1=TRUE,"Display1","") & IF(Condition2=TRUE,"Display2","") & > IF(Condition3=TRUE,"Dis

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

Dear Mahesh Bisht, What i can suggest you is that make use of Pivot Tables for your data if you are familiar. Regards Ahmed Bawazir On Tue, Dec 22, 2009 at 6:53 AM, Mahesh wrote: > Hi Friends, > > Attached herewith is the excel sheet for ur kind consideration. > > Please help. > > -- > With Lo

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

hi mahesh check the sheet, your query has been solved On 12/22/09, Mahesh wrote: > Hi Friends, > > Attached herewith is the excel sheet for ur kind consideration. > > Please help. > > -- > With Love, > Mahesh Bisht > > -- > ---

Re: $$Excel-Macros$$ VBA Password Breaker required

Try Dis Source lostpassword passware enterprise 2670 retail Site www.cwer.ru/files/u5/November07/rapidshare.txt (VISIT IT IF YOU NEED PASSWORD) Back Downloading http://rapidshare.com/files/55040425/

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

Hi Mahesh, Didn't get what you want. Provide more details. Regards, Swapnil. On Tue, Dec 22, 2009 at 9:23 AM, Mahesh wrote: > Hi Friends, > > Attached herewith is the excel sheet for ur kind consideration. > > Please help. > > -- > With Love, > Mahesh Bisht > > -- > >

RE: $$Excel-Macros$$ Nesting of if.....

Hi, You can use as many IF's as you like by using the & symbol. IF(Condition1=TRUE,"Display1","") & IF(Condition2=TRUE,"Display2","") & IF(Condition3=TRUE,"Display3","") etc. Not that the 'Else' part of the if statement needs to be "" Also note that each 'IF' will be evaluated, so if more

$$Excel-Macros$$ Need help on Validation

Hi Friends, Attached herewith is the excel sheet for ur kind consideration. Please help. -- With Love, Mahesh Bisht -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-

$$Excel-Macros$$ Nesting of if.....

Hi Friends, is there any way to use more than 7 ifs in a single formula. Like use it with OR, AND -- With Love, Mahesh Bisht -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text),

Re: $$Excel-Macros$$ SUMIF realted

Wow! that was a great take away Dilip Sir, Thank you very much On Sun, Dec 20, 2009 at 12:57 PM, Dilip Pandey wrote: > Dear Suhas, > > Scenario mentioned by you, has been transformed to a excel spreadsheet and > same is solved and attached herewith. Thanks. > > Best Regards, > -- > DILIP KUMAR

RE: $$Excel-Macros$$ Named ranges in macros

Hi Paul, Thank-you for taking the time to look at this and explain it clearly. I have now found the reference you mentioned in the Help... Excel has a bunch of "interesting" features. Regards - Dave. Date: Mon, 21 Dec 2009 06:03:03 -0800 From: schreiner_p...@att.net Subject: Re: $$Excel-Mac

Re: $$Excel-Macros$$ Time Tracker

Sorry... it's been a while. I keep getting asked to do actual WORK!!! I'm still working on it. There are some oddities in that there are Event Id's and logon types: Event IDs   528 logon  540 logon   538 Logoff  551 User initiated logoff:  513 Windows shutdown  6009 Microsoft (R) Windows (R) 5.01.

Re: $$Excel-Macros$$ Extracting Numbers from the Text

Selva, I couldn't find a simple way to "find" the numbers using standard Excel functions, so I created a function called Get_Number() It will extract only the numbers from the string. take a look. Public Function Get_Number(Str)     Dim I, NumStr     NumStr = ""     For I = 1 To Len(Str)    

$$Excel-Macros$$ Extracting Numbers from the Text

Dear All Excel Gurus, This is my first mail to this group. I have read many mails from this group which is of great useful to me. Currently I am finding a problem in extracting the employee no from the scrambled data. (Attached reference file) What I need is I want to extract out only the

Re: $$Excel-Macros$$ Help Required!

Dear Dilip, Yes. Please go ahead with the revised solution since it looks perfect. Good job sir. Thanks a lot for your efforts. Regards, Sharma On Mon, Dec 21, 2009 at 8:01 PM, Dilip Pandey wrote: > Dear SharmaJi. > > Attached is the revised solution for you with action item at your end. > >

$$Excel-Macros$$ search for common items

I am trying to find a easy way in excel to match and though up options One excel sheet has names and uniqe id of staff ( say 0001,0002... etc) Another excel sheet with code name of training programs ( say 123,b124,C234 ... etc) Some staff have attended some programs. I want excel to through up

Re: $$Excel-Macros$$ Sorting Data

Tommy: Sorry, it looks like my response didn't get sent. How "deep" do you want to go? The fact is: You can name a range to contain the upper section, then either select the named range and sort, or use a macro and do: Sub SortData() ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Clear

Re: $$Excel-Macros$$ How to use Countif across workbook??

You're welcome friend... On Mon, Dec 21, 2009 at 4:18 PM, Deepak Rai wrote: > Hi Abhishek, > > Thanks for the help. It's working fine dear. I am very thankful to you. > > Regards, > > Deepak > > On Mon, Dec 21, 2009 at 4:06 PM, Abhishek Jain wrote: > >> Re-sending with attachments. >> >> >> On M

Re: $$Excel-Macros$$ Named ranges in macros

"I can't fine any reference to this style of notation in the Help": try searching for: "use [" or: "Refer to Cells by Using Shortcut Notation"   It says: "You can use either the A1 reference style or a named range within brackets as a shortcut for the Range property.  You do not have to type the

$$Excel-Macros$$ Dilip Pandey wants to chat

--- Dilip Pandey wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or Google Talk, visit: http://mail.google.com/mail/b-35aadc4bb4-064bdcaf98-b2c9ca5f658af2f9 You'll need to clic

Re: $$Excel-Macros$$ How to use Countif across workbook??

Deepak, That's a limitation with Countif and Sumif. Ofcouse there are workarounds and the easier one would be - to use SUMPRODUCT. Example Syntax - =SUMPRODUCT(--('C:\Myfolder\[AB.xls]Sheet1'!$A$1:$A$28="Apple")) Let me know if there is any issue you may be facing. Kind regards, AJ On Mon,

Re: $$Excel-Macros$$ filtering large data files

Dear John, Can you share a small test file which will have reasonable complexities per your requirement. Do mention the output which you are looking forward. Thanks. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com Ne

Re: $$Excel-Macros$$ filtering large data files

afraid it wouldnt in this case, too many similar characters. i think i would need some kind of macro, or several applying to each combo box. seen it done in access but i have never used it and excel lends itself better to other uses within the file anyway. never written any macros, my knowledge is

Re: $$Excel-Macros$$ Automatic compilation of 5 file in to one

In master file (where you want data to be populated) just provide a link of respective cells ( of Branch files - in your case) So as n when you open Master file, it will come up with a pop up saying that - links available.. do you want to update.. press update n ur data will in masters ! Chee

$$Excel-Macros$$ How to use Countif across workbook??

Hi All, I want to use countif across the workbook. In workbook-1 I have the criteria & I am using countif in it, in workbook-2 I have the range. When I am using countif in workbook-1 it is working only when the workbook-2 is opened, when I close the workbook-2 its not working. Please suggest any a