Excel VBA Function

How to Count Cells by Font Color in Excel

This post will guide you how to count cells by font color in Excel. How do I Count the number of cells with specific cell Font color by using a User Defined function in Excel. Count Cells by Font Color Assuming that you have a list of data in range B1:B9, in which contain some… read more »

How to Highlight Cells Containing Formulas in Excel

This post will guide you how to highlight cells in which contain formulas using Conditional Formatting feature in Excel. How do I conditionally format a cell if it contains formula using a User defined function in combination with Conditional Formatting feature in Excel 2013/2016. Method1: Highlight Cells Containing Formulas Using Defined Name Method2: Highlight Cells… read more »

How to Extract Number from Text String in Excel

This post will guide you how to extract number from a given test string in Excel. How do I extract all numbers from string using a formula in Excel. How to get all number from a given test string using user defined function in Excel. Extract Number from String with Formula Extract Number from String… read more »

How to Filter Data with Strikethrough Format in Excel

This post will guide you how to filter or delete rows with strikethrough format in your selected range of cells in Excel. How do I Filter by strikethrough formatted text with Find and Replace function in Excel 2013/2016. Or how to find cells with strike through formatting in Excel. Filter Data with Strikethrough Formatting Using… read more »

How to Convert a String into a Formula in Excel

This post will guide you how to convert a string into a formula in Excel. How do I turn test strings to a formula for calculation. Convert a String into a Formula Assuming that you have a list of data in range C1:C4, which contains text string (Actually, they are all formulas, but they are… read more »

How to Remove Duplicates in One Cell in Excel

This post will guide you how to remove duplicate characters from a text string in one cell in Excel. How do I remove duplicate words from a cell with a User Defined Function in Excel 2013/2016. Remove Duplicate Characters Remove Duplicate Words Remove Duplicate Characters Assuming that you have a list of data in range… read more »

How to Sort Data by Last Character in Excel

This post will guide you how to sort cells by last character in Excel. How do I sort data by the last character with a formula in Excel. How to sort cells based on the last character with User Defined Function in Excel. Sorting Data by Last Character with Formula Sorting Data by Last Character… read more »

How to Vlookup to Return Multiple Values in Excel

This post will guide you how to vlookup to return multiple values in one cell in Excel. How do I lookup and return multiple values concatenated into one cell with an User defined function in Excel. Vlookup to Return Multiple Values in One Cell Assuming that you have a list of data in range A1:B6,… read more »

How to Generate Random Numbers between Two Numbers in Excel

This post will guide you how to generate random numbers between two numbers in Excel. How do I generate random numbers between two numbers without duplicates with VBA macro in Excel. Generate Random Numbers between Two Numbers with Formula Generate Random Numbers between Two Numbers with VBA Generate Random Numbers between Two Numbers with Formula… read more »

Sidebar