Excel VBA Function

How to Get the Maximum or Minimum Absolute Value in Excel

It is easy to find the maximum or minimum value in a batch of data in excel, but if this batch of numbers contains both positive and negative numbers, the maximum or minimum absolute value cannot be found out by basic MAX or MIN function in excel. This article will help you to solve this… read more »

How to Count Only Numbers in Bold in a Range of Cells in Excel

This post will guide you how to Count only numbers with bold style in a range of cells in Excel. How do I Count on cells with bold font within a range of cells using User defined function in Excel 2013/2016. Count  Only Numbers with Bold Font Style Assuming that you have a list of… read more »

How to Sum Only Numbers in Bold in a Range of Cells in Excel

This post will guide you how to sum only numbers with bold style in a range of cells in Excel. How do I sum on cells with bold font within a range of cells using User defined function in Excel 2013/2016. Sum Bold Numbers Assuming that you have a list of data in range B1:B6,… read more »

How to Filter Formula in Excel

This post will guide you how to filter your data with an Formula in Excel. How do I filter cells with formulas through a User defined function in Excel 2013/2016. Filter Formula Assuming that you have a list of data in range B1:B5, in which contain some text values and formulas. and you want only… read more »

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 »

Sidebar