VB for Applications
Functions
Methods
Properties
Statements
VBA
Count text strings in formulas [VBA]
In this post I will describe a basic user defined function with better search functionality than the array formula in […]
This formula returns multiple values even if they are arranged differently or have minor misspellings compared to the lookup value.
Weekly Blog EMAIL
Get a FREE PDF book!
Formula categories
Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup
Welcome! I am Oscar and here to help you out.Feel free to comment and ask Excel questions.
Make sure you subscribe to my newsletter so you don't miss new blog articles.
Fuzzy lookup
How to use the AMORLINC function
How to use the AMORDEGRC function
How to use the TBILLEQ function
How to use the TBILLPRICE function
How to use the TBILLYIELD function
How to use the UNICODE function
How to use the UNICHAR function
How to use the PERCENTRANK.EXC function
How to use the PERCENTRANK.INC function
How to use the PERCENTRANK function
How to use the EVALUATE method
How to use the QUARTILE.EXC function
How to use the QUARTILE function
How to use the LOGNORM.DIST function
How to use the LOGNORMDIST function
How to use the WEEKNUM function
How to use the LOGEST function
How to use the LINEST function
How to use the GAMMA.DIST function
How to use the ARRAY function [VBA]
How to use the GAMMADIST function
How to use the F.TEST function
How to use the LBOUND and UBOUND functions
How to use the NETWORKDAYS.INTL function
How to use the JOIN function [VBA]
How to use the FORECAST function
How to use the INTERCEPT function
How to use the F.DIST.RT function
How to use the F.DIST function
How to use the EXPONDIST function
How to use the BINOM.INV function
How to use the CRITBINOM function
How to use the CHISQ.TEST function
How to use the CHITEST function
How to use the COVARIANCE.S function
How to use the COVARIANCE.P function
How to customize chart axis titles
How to customize the plot area
How to customize the chart title
How to customize the chart area
How to use the CHISQ.INV.RT function
How to use the CHISQ.INV function
How to use the CHIINV function
How to use the CHISQ.DIST.RT function
How to create a candlestick chart
How to use the CHISQ.DIST function
How to use the CHIDIST function
How to use the BINOM.DIST function
How to use the BINOMDIST function
How to use the BETA.INV function
How to use the BETAINV function
How to use the BETA.DIST function
How to use the BETADIST function
How to use the RANK.EQ function
How to use the CONFIDENCE.T function
How to create a histogram chart
How to use the CONFIDENCE.NORM function
How to use the MODE.SNGL function
How to use the FLOOR.PRECISE function
How to create a waterfall chart
How to use the DOLLARFR function
How to create a doughnut chart
How to use the CUMIPMT function
How to use the CUMPRINC function
How to create a sunburst chart
How to use the GROWTH function
How to use the ERROR.TYPE function
How to use the GEOMEAN function
How to use the RANGE.OFFSET property
How to use the SGN function [VBA]
How to use the WORKDAY function
How to use the YEARFRAC function
How to use the FIX function [VBA]
How to use the INT function [VBA]
How to use the RANGE.FIND method
How to use the PRICEMAT function
How to use the PDURATION function
How to use the CONCATENATE function
Extract unique distinct records from two data sets
How to use the NOMINAL function
How to use the MULTINOMIAL function
How to use the MINIFS function
How to use the MINVERSE function
How to use the NORM.INV function
How to use the SPLIT function [VBA]
How to graph a Normal Distribution
How to use the NORM.DIST function
How to use the WEBSERVICE function
How to quickly select a cell range
How to use the DSTDEVP function
How to use the DSTDEV function
How to use the DPRODUCT function
How to use the DCOUNTA function
How to use the DCOUNT function
How to use the DAVERAGE function
How to use the FORECAST.LINEAR function
How to use the BITXOR function
How to use the BITRSHIFT function
How to use the BITLSHIFT function
How to use the BITAND function
How to use the BIN2OCT function
How to use the BIN2HEX function
How to use the BIN2DEC function
How to use the AVEDEV function
How to convert radians to fractions of pi
How to use the ACCRINTM function
How to use the ACCRINT function
How to use the TRIMMEAN function
How to use the SERIESSUM function
How to use the SUMXMY2 function
How to use the SUMX2PY2 function
How to use the SUMX2MY2 function
How to use the STDEVPA function
How to use the STANDARDIZE function
How to use the STDEV.S function
How to use the STDEV.P function
How to use the RANK.AVG function
How to use the QUARTILE.INC function
How to use the FLOOR.MATH function
How to use the FACTDOUBLE function
How to use the EXPON.DIST function
How to use the EOMONTH function
How to use the ENCODEURL function
How to use the EFFECT function
How to use the DEC2OCT function
How to use the DEC2HEX function
How to use the DEC2BIN function
How to use the DECIMAL function
How to use the CONVERT function
How to use the CONFIDENCE function
How to use the CORREL function
How to use the CONCAT function
How to use the COMPLEX function
How to use the CEILING function
How to use the AVERAGEA function
How to use the TIMEVALUE function
How to use the SWITCH function
How to use the STDEVA function
How to use the SHEETS function
How to use the MROUND function
How to use the MODE.MULT function
How to use the MEDIAN function
How to use the PERMUTATIONA function
How to use the COMBINA function
How to filter using OR logic between columns [Formula]
How to filter using OR logic between columns [Advanced Filter]
How to use the PRODUCT function
How to use the DEGREES function
How to use the RADIANS function
How to use the FORMULATEXT function
How to use the ISFORMULA function
How to use the ISNONTEXT function
How to use the ISLOGICAL function
How to use the ISTEXT function
How to use the ISERROR function
How to use the ISBLANK function
How to use the DATEVALUE function
How to use the WITH … END WITH statement
How to use the DATEDIF function
How to use the DO LOOP statement
How to use the MINUTE function
How to use the RANDBETWEEN function
How to use the SECOND function
How to use the COMBIN function
How to use the PERMUT function
How to remove unwanted characters in a cell
How to use the COUNTBLANK function
How to use the COUNTA function
How to use the COLUMNS function
How to use SELECT CASE statement
How to use the MAXIFS function
How to use the COLUMN function
How to use the FOR NEXT statement
How to use the AVERAGEIFS function
How to use the AVERAGEIF function
How to use the AGGREGATE function
How to use the NETWORKDAYS function
How to use the ADDRESS function
How to use the ISNUMBER function
How to use the WEEKDAY function
How to use the SUBSTITUTE function
How to use the IF THEN ELSE ELSEIF END IF statement [VBA]
How to use the SUMIFS function
How to use the CHOOSE function
Learn how to use the SUBTOTAL function
How to use the HYPERLINK function
Two-dimensional lookup using two tables
Filter values based on numerical ranges
Filter duplicate values using critera
Find last matching value in an unsorted table
How to use the HLOOKUP function
Count matching strings using regular expressions
Fetching values from ThingSpeak using vba
Rotating unique groups with no repeat
Extract cell references from a formula
Working with the LIKE OPERATOR
List permutations with repetition and how many to choose from
List all permutations with a condition
Discover Pivot Tables – Excel’s most powerful feature and also least known
How to use the TEXTJOIN function
Follow stock market trends – trailing stop
Follow stock market trends – Moving Average
Find the highest status and when it was acquired
How to use the TRANSPOSE function
Working with LIST BOXES (Form Controls)
List all hyperlinks in worksheet
Add new items to a drop down list automatically
Permutations with and without repetition
Save selected sheets to a pdf file
Find cells containing formulas with literal (hard coded) values
How to use the LOOKUP function
How to enter array formulas in merged cells
How to use the INDIRECT function
Find the longest/shortest consecutive sequence of a value
Find a sequence of values – wildcard search
Highlight row and column of selected cell
Optimize pick path in a warehouse
A quicker A * pathfinding algorithm
Finding the shortest path – A * pathfinding
Learn Excel’s Subtotal feature
Sort and return unique single digit numbers
Print screen the entire worksheet
5 most popular blog posts 2013
All you need to know about calculating NAV units for your stock portfolio
Lookup with an unknown number of criteria
Select and delete cells and formulas that return nothing
Prevent duplicate records [Data Validation]
Basic mathematics in excel for school children
Count text strings in formulas [VBA]
Quickly select a data set or an excel defined table [HYPERLINK]
Quickly jump to last row in a data set using excel hyperlink function
How to use the IFERROR function
Locate a particular cell in a table
How to generate random numbers and text
How to use the FREQUENCY function
How to use the SEARCH function
How to use the COUNTIFS function
How to use the COUNTIF function
Lookup using multiple conditions
Convert array formula to a regular formula
Dynamic data labels in a chart
Find max unique value from a range that have duplicate numbers and blanks
Compare your stock portfolio with S&P500 in Excel
Locate lookup values in a table [HYPERLINK]
Use Conditional Formatting to do lookups in related tables
Working with three related tables
Extract unique distinct values from a related table
Lookups in a related table (array formula)
Copy each sheet in active workbook to new workbooks
Quickly search a data set with many criteria
Extract cell references from all cell ranges populated with values in a sheet
Quickly create links to sheets, tables, pivot tables and named ranges in a workbook
Create links to all sheets in a workbook
Plot buy and sell points in an excel chart using two moving averages
Add buy and sell points to a stock chart
Create comments in cells whose value is larger than the column width
Lookup multiple values in different columns and return a single value
Unique distinct records sorted by frequency
Add or remove a value in a drop down list
Use a drop down list to select company info in header (vba)
How to create random numbers, text strings, dates and time values
Dependent data validation lists in multiple rows
Auto resize columns as you type
Easily identify groups of duplicate rows
Select numbers in each permutation
Filter unique distinct records using criteria
VLOOKUP in a filtered Excel Table and return multiple values
Insert blank rows for missing values
Fuzzy lookups [UDF]
Invoice template with dependent drop down lists
Create dependent drop down lists containing unique distinct values in multiple rows
Extract unique distinct values based on the 4 last characters
Apply dependent combo box selections to a filter
Create a drop down list containing alphabetically sorted values
Case sensitive lookup and return multiple values
Schedule recurring expenses in a calendar in excel (Personal Finance)
Create dependent drop down lists containing unique distinct values
Calculate your stock portfolio performance with Net Asset Value based on units in excel
Automate net asset value (NAV) calculation on your stock portfolio
Using Excel Solver to schedule employees
Find positive and negative amounts that net to zero
Identify missing three character alpha code numbers
Create a drop down list containing only unique distinct alphabetically sorted text values
Create a list of duplicates where adjacent cell value meets a condition
How to rank text uniquely without duplicates
How to identify two consecutive dates in a list
How to navigate quickly in a complex workbook using hyperlinks
How to extract email addresses from an Excel sheet
Filter unique distinct records
How to use the OFFSET function
Find the smallest value in a list that is larger than a number
Create a numbered list ignoring blank cells
List all named ranges and their cell references
Print consecutive page numbers across multiple worksheets
Repeat headers on every page you print
Function Reference Formulas Charts Conditional Formatting Excel Tables Pivot Tables VBA Knowledge Base Macros User Defined Functions Videos Advanced Excel CourseMost used functions
COUNTIF function INDEX function IF function SUM function SUMIFS function SUMPRODUCT function VLOOKUP function