<P>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. <P>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. <P>Two Column Lookup to Find N'th Occurrence: <P>Sum Every Nth <P>Sum The X Smallest/Largest Numbers In Row or Columm <P>Sum by Color-Count by Color <P>Sum Excel Ranges Diagonally <P>Sum Excel Range Meeting Up To 5 Conditions <P>A Single Function That Will SUM or COUNT Cells By Their Fill Color <P>Count Words <P> Count or Sum Specified Number In Cell Housing Many Numbers <P>Extract Numbers from Text Strings <P> List/Return Difference Between 2 Cells Containing Comma Separated Strings <P>Sort by Color <P>Workbook Name in Cell <P>VLOOKUP Across Multiple Sheet <P>Extract Last Word <P>Non Repeating Random Numbers <P>Get Cell Comment Text Into Cell <P>Interior Cell Color by Index or Name <P>Reverse Cell Content <P>Get Highest Number Between Nominated Range <P> <BR> Microsofts Convert a Numeric Value into English Words<BR> <BR> Microsofts Convert a Currency or Value into English Words <P> <BR> Get Hyperlink Address <P> <BR> Does Cell Have a Formula <P>2 Functions To Determine Excel Calculation Status & Mode<BR> <BR> Extract File Name from Full Path Name <P> <BR> Does an Excel Workbook Exists or Not? <P>Extract nth Word From Text in Excel <P>How Many Specified Days in a Month <P>Determine nth Weekday of a Specified Date <P>Calculate Sliding Scale Tax <P> <BR> Display AutoFilter Criteria <P> <BR> Return Date of Last Chosen Day of Given Month<BR> <BR> Return Date of the First, or nth Day of Month <P> <BR> Count One Instance of Each Entry <P> Lookup any occurrence from any column and offset left or right <P> 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. |
