User Defined Function
Excel ยป VBA ยป User Defined Function ยป
Extract text between words [UDF]
Blake asks: I have a somewhat related question, if you don't mind: I have very large amount of text in [โฆ]
Search for a file in folder and subfolders [UDF]
The image above demonstrates a user-defined function in cell range B6:D7 that allows you to search a folder and subfolders [โฆ]
Split search value using delimiter and search for each substring
Anil asks: I have A1(anil singh raj) It can be anything Like A1(singh raj anil) I want return value in [โฆ]
The "Text to columns" feature in excel lets you split multiple values in a single cell using a delimiting character, [โฆ]
Count comma separated values [UDF]
I received an email from one of my seven blog readers. In Excel, I have a column, say A, with some [โฆ]
Count cells by cell and font color
Dave asks: How difficult would it be to make it count colour alone (so not unique values) and / or [โฆ]
Substitute multiple text strings [UDF]
The user defined function demonstrated below replaces multiple old text strings with new text strings in a cell. The custom [โฆ]
Lookup multiple values in one cell [UDF]
This article explains how to perform multiple lookups based on values in one cell with a delimiting character using a [โฆ]
Learn how to return values based on where you enter the UDF
In this vba tutorial I am going to show you how to return values from an udf, depending on where [โฆ]
Extract unique distinct values from a filtered Excel defined Table [UDF and Formula]
Robert Jr asks: Oscar, I am using the VBA code & FilterUniqueSort array to generate unique lists that drive Selection [โฆ]
Sean asks: Sheet1A B C D 8 Country Europe 9 Lights 100 10 Type A 200 11 12 Country USA [โฆ]
Two-way lookup using multiple tables [UDF]
This article describes a User Defined Function that lookups values in multiple cross reference tables based on two conditions. A [โฆ]
SUMIF across multiple sheets [UDF]
This post describes a User Defined Function that searches multiple ranges and adds corresponding values across worksheets in a workbook. A [โฆ]
List files in a folder and subfolders [UDF]
This article demonstrates a user defined function that lists files in a ggiven folder and subfolders. A user defined function is [โฆ]
How to save custom functions and macros to an Add-In
Macros and custom functions are great, they can automate many tedious tasks. To have them available whenever you need them, [โฆ]
Filter unique distinct records (case sensitive) [UDF]
The User Defined Function demonstrated above extracts unique distinct records also considering upper and lower case letters. For example, a record [โฆ]
Filter unique distinct values (case sensitive) [UDF]
The User Defined Function demonstrated in the above picture extracts unique distinct values also considering lower and upper case letters. [โฆ]
How to count word frequency in a cell range [UDF]
This user defined function creates a unique distinct list of words and how many times they occur in the selected [โฆ]
In this post I will describe a basic user defined function with better search functionality than the array formula in [โฆ]
Filter words containing a given string in a cell range [UDF]
The image above demonstrates a User Defined Function that extracts all words containing a given string that you can specify. In [โฆ]
Find positive and negative amounts that net to zero [UDF]
Question:I would like to reduce the number of open items by identifying positive and negative amounts that net to zero [โฆ]
This article describes how to find a sum from a range of numbers using a user defined function. Letยดs see [โฆ]
List permutations without repetition [UDF]
This blog post describes how to create permutations, repetition is NOT allowed. Permutations are items arranged in a given order meaning [โฆ]
List permutations with repetition [UDF]
This blog post demonstrates a custom function (UDF) that creates permutations. Repetition is allowed. The custom function lets you specify the [โฆ]
Filter not shared values out of two cell ranges [UDF]
This post describes a custom function (User defined Function) that extract values existing only in one out of two cell [โฆ]
Filter values in common between two cell ranges [UDF]
I tried the array formula in this post: Filter common values between two ranges using array formula in excel to [โฆ]
Filter duplicates in a large dataset [UDF]
This article demonstrates a user defined function that extracts duplicate values and also count duplicates. Example, the image below shows a list containing [โฆ]
Count unique distinct values in a large dataset [UDF]
This article describes how to count unique distinct values in list. What is a unique distinct list? Merge all duplicates to one [โฆ]
Filter unique words from a range [UDF]
This blog post describes how to create a list of unique words from a cell range. Unique words are all [โฆ]
Filter unique distinct words from a cell range [UDF]
This blog post describes how to create a list of unique distinct words from a cell range. Unique distinct words [โฆ]
Filter duplicate words from a cell range [UDF]
AJ Serrano asks: I have a column where each rows contains different values and I wanted to obtain the duplicate [โฆ]
Split words in a cell range into a cell each [UDF]
This post describes how to split words in a cell range into a cell each using a custom function. I [โฆ]
Split values equally into groups
Question: How do I divide values equally into groups (3 lists or less)? This post shows you two different approaches, [โฆ]