Excel Forum
Similar Content
Create a Custom Function in Excel - UDF
Tutorial: How to create a custom worksheet function in Excel. These are called User Defined Function...
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
HLOOKUP in Excel
Tutorial: The Hlookup function allows you to scan a row from left to right in search of a value and ...

Excel Magic Trick 276 MoreFunc Excel add-in 66 New functions

See how to download and install MoreFunc. See new functions like:
EVAL evaluates a text string
FILENAME gives workbook name
FILENAME gives file path
FORMULATEXT shows formula in cell as text
MRAND randomly generates numbers without repeating numbers. Series of random integers without repetitions
COUNTDIFF counts unique records in a list
MCONCAT concatenates arrays
NBTEXT converts numbers to words

Got a Question? Ask it Here in the Forum.