Search results for query: *

hello In my humble opinion the best way to do it is with pivot tables working with multiple consolidation ranges give it a try , in my example worked fine Best Regards Andreas using xl2002 on winxp

Hello you can user vlookup function , or index-match combination please give a more detailed example of what you need so we can help you more Best Regards Andreas using xl2002 on winxp

Hello You can use either of these user defined functions depending on what you want. Private Declare Function api_GetUserName Lib "advapi32.dll" Alias "GetUserNameA" _ (ByVal lpbuffer As String, nsize As Long) As Long ' Function to get back the Network User ID Public Function GetUser()...

hello go to the excel help, answer wizzard and type Fill in a series of numbers, dates, or other items hth Best Regards Andreas using xl2000 on win2k

hello there friends fyi this is the solution , thanks to Tim Urtis for his Help ------------------------------------------------------- Private Sub Workbook_BeforePrint(Cancel As Boolean) Application.ScreenUpdating = False Application.EnableEvents = False Dim LastPage As Long, PageNumber As...

Hello I work with excel 2000 and i want to print a specific line of text ( footer) automatically only on the last printed page. for example i have an excel sheet which is 3 pages printed i want the text " bla bla bla bla " to be printed only on the footer of the 3rd page Is there...

Hello You can use sumproduct function too =sumproduct((A1:A10)=&quot;Albany, NY&quot;)*(B1:B10<>&quot;&quot;)) without using array formulas , which are slow and resource consuming on big data. hth Best Regards Andreas using xl2000 on win2k

hello take a look here http://www.slipstick.com/outlook/ol2002/missing.htm it might help Best Regards Andreas using xl2000 on win2k

hello select the range, go to Edit,replace , and check the &quot;find entire cells only&quot; option. it works for me xl2000 hth Best Regards Andreas using xl2000 on win2k

hello take a look at this link http://support.microsoft.com/default.aspx?scid=kb;EN-US;q255503 hth Best Regards Andreas using xl2000 on win2k

Hello check this link, it might help you http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q157486& Best Regards Andreas using xl2000 on win2k

hello Mouseman take a look at this article in Microsoft's site it might help http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q141695& Best Regards Andreas using xl2000 on win2k

Please be more specific, give an example of your data so we can help you find the solution. Andreas using xl2000 on win2k

hello JBTEX You must import the numbers as text not as general format Excel maintains only 15 significant digits for numbers thus your problem. hth Andreas using xl2000 on win2k

Hello Steve you can use the sumproduct function =SUMPRODUCT((S2:S202=2)*(W2:W202=&quot;F&quot;)) HTH Andreas using xl2000 on win2k