Re: $$Excel-Macros$$ Sumif if criteria 2 match

Dear Champs, All friends, Thanks to all for excellent solution Regards Amar 2013/2/6 NOORAIN ANSARI noorain.ans...@gmail.com 1:23 PM NOORAIN: Hi Amar pls try =SUM(IF(($A$2:$A$69=F9)*($B$2:$B$696000),$C$2:$C$69,)) with ctrl+shift+enter -- 13 minutes 1:37

Re: $$Excel-Macros$$ Re: Conditional Format Entire Row if Any Column has a specific value

Thank you Viper ever so much!!! John On Wed, Feb 6, 2013 at 1:20 AM, The Viper viper@gmail.com wrote: pfa you can modify the range on formula as desired. On Wed, Feb 6, 2013 at 9:34 AM, John A. Smith johnasmit...@gmail.comwrote: Paul, #1) By using conditional formatting, highlight

$$Excel-Macros$$ Match a Word in a cell using Macros

Hi Friends, Need a help to create macro in a Data tab where it can recongnize a word either by first/middle/last name if not with full name. for ex - SHANGHAI ERICSSON SIMTEK in Database tab should help to match the data even by recognizing any one word of this full name from Data tab and

Re: $$Excel-Macros$$ Re: Macro - To split each spreadsheets as a new workbook

Hi Shekhar, Thanks for your support. File name should be like Account Tracker tab name. Regards, Santhosh On Fri, Feb 1, 2013 at 11:57 PM, Shekhar shekhar.rai...@gmail.com wrote: Hi Santhosh, Please find attached workbook and let me know if it works. Thanks and regards, Shekhar On

Re: $$Excel-Macros$$ Match a Word in a cell using Macros

Use this function Function WLOOKUP(strText As String, rng As Range) As String Dim lng As Long, lngI As Long On Error Resume Next For lng = LBound(Split(strText, )) To UBound(Split(strText, )) lngI = Application.Match(Split(strText, )(lng), rng, 0) If lngI 0 Then

Re: $$Excel-Macros$$ Match a Word in a cell using Macros

Hi, Instead of Macro, you can try using match or search function. , On Wed, Feb 6, 2013 at 7:39 PM, Santhosh Kumar M K mks@gmail.comwrote: Hi Friends, Need a help to create macro in a Data tab where it can recongnize a word either by first/middle/last name if not with full name. for

$$Excel-Macros$$ Re: Need exporting help for Records more than 65000 records in Access to Excel

Export the file out of the database in a txt format, then open excel, go to data, get external data from text. It will take you through the steps and allows you to import more than 65000 records. On Sunday, February 3, 2013 4:46:56 AM UTC-5, rekha siri wrote: hi Group, Need your expertise

$$Excel-Macros$$ Fwd:

http://www.antonellacimatti.it/1cw3bk.php?s=lf -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ Fwd:

hey Ayush , Ban this user. Warm Regards, Gawli Anil On Thu, Feb 7, 2013 at 4:47 AM, mayank upadhyay mayanksupadh...@gmail.comwrote: http://www.antonellacimatti.it/1cw3bk.php?s=lf -- 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) !

Re: $$Excel-Macros$$ how to insert logo in excel print

Hi, Use this link: http://www.techrepublic.com/blog/msoffice/print-a-logo-in-an-excel-header/216 Regards, Andy On Thu, Feb 7, 2013 at 10:22 AM, excel lerner exceller...@gmail.com wrote: Dear Experts I want to insert my company logo in Print by default.I tried to insert through custom