Home > Excel > Functions on ranges
Top-Rated Links 
Most-Visited Links 

Functions on ranges

Excel Custom Functions Update Link / Bad Link? 
Here you will find many custom Excel functions (UDF's) and examples of how to add descriptions to your UDF's and even add you own catergory in the Standard Excel Function wizard. There is also an objective look at UDF's.
Submitted Jun 28, 2002
Rating: (2 Ratings)   Rate this link Total Visits: 468
 
Mark's Maths and Excel Homepage Update Link / Bad Link? 
Two pages of Excel Tutorial files and associated Word files - A 'Named Range' Tutorial and a 'VBA Introduction' Tutorial. Both Tutorials have a Mathematical Basis and several focus on animating graphs.
Submitted Jul 02, 2001
Updated Nov 29, 2004 by ilker ertas
Rating: (2 Ratings)   Rate this link Total Visits: 316
 
Excel Business Functions Update Link / Bad Link? 
Add up to 350 new functions into Excel. These are not Custom Functions written in VBA, but Excel functions using the much faster C++ language!
Submitted Nov 11, 2002
Updated Oct 05, 2005 by John Drummond
Rating: (1 Ratings)   Rate this link Total Visits: 261
 
Highlight Duplicates in Excel Update Link / Bad Link? 
Example of how we can use Conditional Formatting to highlight duplicates in Excel
Submitted Jul 04, 2005 by Dave
Updated Jul 05, 2005
Rating: N/A   Rate this link Total Visits: 77
 
Apricot Software - Unit Conversion Excel Addin Update Link / Bad Link? 
Flexible unit conversion addin that uses simple text strings to specify conversions. New units can be defined in this data driven system. Derived units can be built on the fly. Dimensional analysis is used to ensure that the conversion is legitimate. This system really understands unit conversion and is not constrained to fixed lists.
Submitted Oct 01, 2001
Updated Aug 10, 2005 by Dave Moran
Rating: N/A   Rate this link Total Visits: 67
 
SheetStats Update Link / Bad Link? 
SheetStats provides sheet statistics in a MsgBox.
Submitted Sep 28, 1999
Rating: N/A   Rate this link Total Visits: 59
 
SHSORT01.ZIP Update Link / Bad Link? 
SHSORT01.XLA is an Excel AddIn that sorts the Sheets in the ActiveWorkbook in alphabetical order. Not earthshaking exactly but quite useful when that sad time comes to document a huge project workbook you've been banging away on for weeks with 17 Modules, 12 Worksheets, 15 Dialogs, 7 Charts and a XLM macro for setting Page attributes thrown in for good measure.
Submitted Sep 07, 1999
Rating: N/A   Rate this link Total Visits: 30
 
  Link To Us

Terms of Use:  
NOTICE: Links you submit to Mathtools.net Link Exchange will be accessible from any part of the world via the web. Any information such links contain may be used by The MathWorks and the public, both within and outside the country from which you posted. Read complete disclaimer prior to use.


  Privacy - Trademarks - Feedback - Terms of Use Copyright 2001-2008 The MathWorks Inc.