Learn Microsoft Excel Online FreeThis post will guide you how to count cells between two dates with multiple criteria in excel. How do I count records between two dates and multiple criteria with formula in excel. You can easily count cells between two dates using COUNTIFS function. and if you want to count records between two dates with two… read more »
This post will guide you how to find the maximal and minimal value or string from an alphanumeric data list in excel. How do I retrieve or get the max or min string value based on alphabetic order from a string data in excel. For example, if you want to find the Maximal or minimal… read more »
This post will guide you how to highlight values that end with a specific character or text string in excel. How do I highlight cells that end with a string using the conditional formatting feature in excel. Assuming that you want to highlight cells that end with the text string “excel” in the range A1:B4,… read more »
This post will discuss that how to count the number of cells that contain specific text or certain text in a specified cells of range in Excel. How to get the total number of cells that contain certain text. Count Cells That Contain Specific Text Assuming that you have a data of list in range… read more »
This post will explain that how to get the maximal or minimal string based on the alphabetic order from a range of cells in Excel. You will learn that how to use the Excel Functions to find or extract the Maximal string or Minimal string based on alphabetic order from a specified range of cells…. read more »
This tutorial will show you how to find duplicate values in two given columns in Excel. Or How to compare two columns and find duplicate entries in Microsoft Excel worksheet. And you will learn two methods to compare columns so that the duplicate values can be highlighted or listed in a range of Cells. Assuming… read more »
This tutorial will teach you how to highlight duplicates rows using conditional formatting feature in Excel. In the previous post, we talked that how to change the color of rows based on a certain number or text or begin a specific character in a specified column. And this post will talk that how to highlight… read more »
This post will guide you how to count for duplicates in Excel. You will learn how to count the instances of each duplicate value in a column. You can use the COUNTIF function to count the duplicate values in a column in Excel. If you have a list of data that contain duplicated values in… read more »
This post explains that how to count numbers with leading zeros as Text format in excel. How to count numeric format strings with a different number of leading zeros using excel formula. Count Strings with Leading Zeros Suppost you have a list of product ID in your worksheet, and the product ID contains the different… read more »
This post explains that how to get the unique values from a range or column in excel. How to extract unique values from a list or excel range in excel 2013. Extract unique values If you want to extract a list of unique items from a column or range, you can use a combination of… read more »
