Custom Excel Functions Add-In
- License: Purchase
- Discount: 15% OFF valid until Jul 31, 2010
- Sale Price:
$9.95 USD$8.46 USD (You save $1.5 USD) - Operating Systems: Windows 95/98/ME,Windows NT/2000,Windows XP,Windows Vista
- Additional Requirements: Excel 97 or above
- Publisher: Dave Hawley
- Average User Rating:
(click to vote)
Loading ...
After you install the add-in, you will have new Category in Excel's
Native “Insert Function” dialog box. Most Custom Functions are grouped
together. That is,
B_ =Boolean (TRUE/FALSE) Function
C_ =Color Function
D_ =Date Function,
L_ =Lookup Function.
S_ =String (Text) Function.
PRE200* means the lowest version the custom function will
work on. Please note, that the SpellDollarVal is
NOT written by Ozgrid. It was written by Microsoft.
Two Column Lookup
to Find N'th Occurrence:
Sum Every Nth
Sum The X Smallest/Largest Numbers In Row or Columm
Sum by Color-Count by
Color
Sum Excel Ranges Diagonally
Sum Excel Range Meeting Up To 5 Conditions
A Single Function That Will
SUM or COUNT Cells
By Their Fill Color
Count Words
Count
or Sum Specified Number In Cell Housing Many Numbers
Extract Numbers
from Text Strings
List/Return
Difference Between 2 Cells Containing Comma Separated Strings
Sort by Color
Workbook Name
in Cell
VLOOKUP
Across Multiple Sheet
Extract
Last Word
Non Repeating
Random Numbers
Get Cell
Comment Text Into Cell
Interior
Cell Color by Index or Name
Reverse Cell
Content
Get Highest
Number Between Nominated Range
Microsofts
Convert a Numeric Value into
English Words
Microsofts
Convert a Currency or Value
into English Words
Get Hyperlink Address
Does Cell Have a Formula
2 Functions To Determine Excel Calculation Status & Mode
Extract File
Name from Full Path Name
Does an Excel
Workbook Exists or Not?
Extract
nth Word From Text in Excel
How Many Specified
Days in a Month
Determine nth Weekday of a Specified Date
Calculate
Sliding Scale Tax
Display AutoFilter
Criteria
Return Date of Last
Chosen Day of Given Month
Return Date of the First,
or nth Day of Month
Count One Instance
of Each Entry
Lookup any
occurrence from any column and offset left or right
The Ultimate Excel Lookup Function This Custom Function will look in
any column, unless specified, for the nth occurrence of the specified
value and return the corresponding value x rows above or below the found
value to the left or right.
Custom Excel Functions Add-In Screenshot
Possibly Related Software
Password For Ozgrid Custom Functions Add-in
After you install the add-in, you will have new Category in Excel's Native "Insert Function" dialog box. Most Custom Functions are grouped together. That is, Function preceded with L_ means it's a Lookup Function. D_ means Date Function, B_ mean...
Excel OCX
Excel OCX by SkySof Software Inc (www.skysof.com) is a powerful ActiveX control for software developers which contains a smorgasborg of functions to exchange data between Excel and Visual Basic, create professional looking reports in Excel, and muc...
Excel Class .NET
Excel Class .NET is a powerful .NET component written in Visual Basic .NET (ensuring maximum compatibility, ease-of-use and effectiveness) which contains a smorgasborg of functions to exchange data between Excel and .NET, create professional lookin...
This entry tagged with Dave Hawley and is filed under Business & Finance, Spreadsheets, Windows 95/98/ME, Windows NT/2000, Windows Vista, Windows XP.