Re: $$Excel-Macros$$ Company name based on maximum occurrence

2015-09-23 Thread Suman
Dear Paul, Thanks you so much its working fine!! I'm still learner and starting of the stair in VBA but you are awesome. *Suman Kumar* On Wed, Sep 16, 2015 at 7:57 PM, Paul Schreiner wrote: > OK, here's the approach I took. > First: For Testing purposes I created a sample list of 10,00

$$Excel-Macros$$ Explanation for a code

2015-09-23 Thread Mandeep Baluja
Dear Paul, Could you please let me know the explanation of this code after for loop as I am unable to understand the same ?? Sub CombineRows() 'Update 20130829 Dim WorkRng As Range Dim Dic As Variant Dim arr As Variant On Error Resume Next Set WorkRng = Application.Selection Set WorkRng = App

$$Excel-Macros$$ Client in Houston TX need WebPortal Developer (.NET)with Aqua Logic and EDK

2015-09-23 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great Please send resume to ma...@genuineitllc.com *TITLE :WebPortal Developer (.NET)* *Location: North Houston* *Duration: 12 months* *Need someone with Aqua Logic (formerly Plumtree) and someone with EDK (enterprise development toolkit) * *These are comp

$$Excel-Macros$$ Backfill - Client in Houston TX need SAP Business Objects Developer/Admin

2015-09-23 Thread MADHU-GenuineItLlc
Hi Partner , Please send resume to ma...@genuineitllc.com This is a backfill for someone that just put in their 1 week notice at client in downtown *Houston* for a *SAP BOBJ Developer.* Below is the skillset for what needs to be replaced; let me know if you have anyone. *Start: Monday, 9/28

$$Excel-Macros$$ Client in Houston TX need PowerBuilder with .Net Developer

2015-09-23 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great Please send resume to ma...@genuineitllc.com PowerBuilder / .Net Developer- On behalf on our client in the Oil and Gas sector, We ar looking for 5 PowerBuilder/.Net Developers. The successful candidates must have a strong experience with Powerbuilder, .Net

$$Excel-Macros$$ Client in Houston TX need PowerBuilder / .Net Developer

2015-09-23 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great Please send resume to ma...@genuineitllc.com PowerBuilder / .Net Developer- On behalf on our client in the Oil and Gas sector, We ar looking for 5 PowerBuilder/.Net Developers. The successful candidates must have a strong experience with Powerbuilder, .Net

$$Excel-Macros$$ Word count match in two columns

2015-09-23 Thread Anand Tiwari
Is there any formula to match the number of words in row1 of column 1 to row 1 of column 2 *For example* Palmer's Cocoa Butter Formula with Vitamin E Skin Therapy Oil - 5.1 fl oz ​ Palmer's Cocoa Butter Formula with Vitamin E Skin Therapy Oil Number of words matched = 10 *Column 1* Palmer's Co

Re: $$Excel-Macros$$ MSG: Code execution has been interrupted

2015-09-23 Thread Gaurav Devrani
Hi Pravin, Give it a try with this code in the beginning of your macro. application.EnableCancelKey=xlDisabled I am not 100% sure. But let me know whatever happens. On Sat, Sep 19, 2015 at 2:15 AM, Pravin Gunjal wrote: > Hi, > > I am getting an above mentioned error message while running an

Re: $$Excel-Macros$$ Re: Data Extract After "/"

2015-09-23 Thread Anand Tiwari
On 23 September 2015 at 16:35, Mandeep Baluja wrote: > 999 ​Thanks you so much Mandeep Jee​ *Regards,* *Anand Tiwari* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/dis

$$Excel-Macros$$ Re: Data Extract After "/"

2015-09-23 Thread Mandeep Baluja
change f5 the cell reference as per your need =RIGHT(F5,LEN(F5)-LOOKUP(99,FIND("/",F5,ROW(INDIRECT("1:"&LEN(F5)) press ctrl +shift+enter Regards, Mandeep baluja https://www.facebook.com/groups/825221420889809/ On Wednesday, September 23, 2015 at 12:04:06 PM UTC+5:30, Anand Tiwari