Below is a list of Excel VBA functions sorted alphabetically. If you would like a list of these functions sorted by category, click on the following button:Sort AlphabeticallySearch VBA functions: (Enter a value in the field above to quickly find functions in the list below)...
Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column. ...
MID, MIDB functions Text: Returns a specific number of characters from a text string starting at the position you specify MIN function Statistical: Returns the minimum value in a list of arguments MINIFS function Statistical: Returns the minimum value among cells specified by a given set of...
aka user-defined functions (UDF). These are VBA-based functions that extend the basics of Excel with custom functionality. Select a category to go to the functions list with short descriptions and links to examples of use
If you find yourself with a two-dimensional array that you would like to convert to a simple list, use TOROW and TOCOL to convert a 2D array into a single row or column of data.\n\n Using the WRAPROWS and WRAPCOLS functions, do the opposite: create a 2D array of a specified ...
You can also browse through Excel's extensive library of functions. In the ribbon, click Formulas. Select Insert Function. To browse functions by category, click the Select category dropdown. Click on any function, and a description of how it works appears beneath the list of functions. ...
You can use Excel to perform a variety of automatic, manual, and iterative calculations. Excel uses functions to perform these calculations. For more information, seeExcel functions by category. Cell references in formulas You can use cell references in formulas. When yourefer to a cell or ...
Here I have listed the Top 100 VBA Functions (Category Wise) in detail with examples and sample codes. These functions are listed under specific categories (10) to help you understand the purpose of each function easily. Below is the list of categories of the major VBA functions. All the ...
Here's a list of features and functions that you can find in WPS Office: Writer (Word Processing) Rich text editing tools Support for various document formats, including DOC, DOCX, and more Page layout customisation Templates for documents ...
You'll use the CONTOSO namespace to access the custom functions in Excel.Next, try out the ADD custom function by completing the following steps.In Excel, go to any cell and enter =CONTOSO. Notice that the autocomplete menu shows the list of all functions in the CONTOSO namespace. Run ...