$$Excel-Macros$$ JOB

2011-10-16 Thread NOORAIN ANSARI
*Experience:* 3 - 6 Years *Location:* Noida *Education:* UG - Any Graduate - Any Specialization,Graduation Not Required PG - Any PG Course - Any Specialization,Post Graduation Not Required *Industry Type:* IT-Software/ Software Services *Role:* System Admin *Functional Area:* IT-Other *Posted Date:

$$Excel-Macros$$ auto complete feature in drop down list or combo box

2011-10-16 Thread ajjw123
can anybody help me with auto complete feature incorporation in drop down list or in a combo box.thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.c

Re: $$Excel-Macros$$ Plotting without zero's at end of plot

2011-10-16 Thread dguillett1
Send your file with a complete explanation and before/after examples to dguillett1@gmail.com Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Ken Sent: Sunday, October 16, 2011 2:29 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Plotting

$$Excel-Macros$$ Plotting without zero's at end of plot

2011-10-16 Thread Ken
I have a sheet where I am listing the data (numbers) in columns. I add data at the bottom of the columns as I get it. I plot a single column of data using the offset function within a Named range to set the data to plot against the number of data points input; plus a few blank rows (e.g. 30) below

Re: $$Excel-Macros$$ How to extract number in cell

2011-10-16 Thread Dilip Pandey
Excellent formula Sam... Awesome Regards, DILIPandey On 10/16/11, Sam Mathai Chacko wrote: > In keeping with Noorain's VBA function, use this formula as an array. This > extracts all numbers irrespective of whether the numbers are together, or > scattered across the text like ABC123DEF, or A

Re: $$Excel-Macros$$ How to extract number in cell

2011-10-16 Thread Sam Mathai Chacko
In keeping with Noorain's VBA function, use this formula as an array. This extracts all numbers irrespective of whether the numbers are together, or scattered across the text like ABC123DEF, or A1B2CD3EF =SUM(IFERROR(MID(A1,LARGE(ISNUMBER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)^0)*ROW(INDIRECT("1:"&

Re: $$Excel-Macros$$ How to extract number in cell

2011-10-16 Thread NOORAIN ANSARI
Dear Neil, Please try it to find integer.. Function only_integer(rng As Range) Dim i As Integer For i = 1 To Len(rng) If VBA.IsNumeric(Mid(rng, i, 1)) = True Then only_integer = only_integer & Val(Mid(rng, i, 1)) End If Next End Function -- Thanks & regards, Noorain Ansari *http://exc

Re: $$Excel-Macros$$ How to extract number in cell

2011-10-16 Thread Dilip Pandey
Nice work Don..!! Regards, DILIPandey On 10/16/11, dguillett1 wrote: > Array formula solution > > =1*MID(J3,MATCH(TRUE,ISNUMBER(1*MID(J3,ROW($1:$9),1)),0),COUNT(1*MID(J3,ROW($1:$9),1))) > > Macro > Sub ExtractNumbers() > Dim r As Range > Dim s As String > Dim v As Variant > > Set r = Range

Re: $$Excel-Macros$$ How to extract number in cell

2011-10-16 Thread dguillett1
Array formula solution =1*MID(J3,MATCH(TRUE,ISNUMBER(1*MID(J3,ROW($1:$9),1)),0),COUNT(1*MID(J3,ROW($1:$9),1))) Macro Sub ExtractNumbers() Dim r As Range Dim s As String Dim v As Variant Set r = Range("j3", Range("j3").End(xlDown)) s = Join(Application.Transpose(r)) With CreateObj

RE: $$Excel-Macros$$ Formula needed to extract the text from string

2011-10-16 Thread Dilip Pandey
You are welcome. Regards, DILIPandey On 16 Oct 2011 14:16, "Anil Bhange" wrote: > Amazing... I know this group can help me... it save my lot of time... > > Thanks Dilip & Ashish > > Regards,Anil Bhange > IP Phone - 512320 | Mobile - 90290 32123 > > -Original Message- > From: Dilip Pa

$$Excel-Macros$$ How to extract number in cell

2011-10-16 Thread neil johnson
Hi All, How to extract number form the cell . For example abc123abc wc34agh 783abcd Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceld

Re: $$Excel-Macros$$ Working out of Statistics on Exam Results URGENT solution needed!

2011-10-16 Thread shaneallen
hi can u show me how to import the info to the different cells in each field? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join

Re: $$Excel-Macros$$ Toggle a Cell value

2011-10-16 Thread Sam Mathai Chacko
I don't necessarily support this alternative, and I don't think it is popular among the old schools either, but it is effective nonetheless. There is a certain Hyperlink event which could be modified to bamboozle Excel and make it work to your advantage. The trick is to create a hyperlink to the sa