Learn Microsoft Excel Online FreeThis post will discuss that how to find and get the Nth largest unique value in a range of cells in Excel. Normally, you can use the LARGE function to get the first or second or nth largest value, but it cannot be filtered the duplicated values. Get nth Largest Value with Duplicates If you… read more »
This post will guide you how to sum data by group in a table in Excel. Assuming that you have a table that contain the product name and its sales result. And you have group by those values based on the product name, then you want to sum values based one each product name. You… 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 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 »
In the previous post, we talked that how to highlight duplicate rows with conditional formatting feature in excel. And this post will teach you how to find duplicate rows with an excel formula. If you want to check the entire row that duplicated or not, if True, then returns “duplicates” value, otherwise, returns “no duplicates”…. 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 will guide you how to sort full name by middle name in excel 2013, or 2016. How do I sort names by middle name with excel formula. How to sort full names by middle name using Text to Columns command in excel. Sort Names by Middle Name using Excel Formula Assuming that you… read more »
This post will guide you how to extract the first word from a text string in excel. How to get the first word in a text using excel formula. Get First word If you want to extract the first word from a text string in a cell, you can use a combination of the IF… read more »
In the previous post, we talked that how to count the number of words in a single cell. And this post explains that how to count the number of words in a range of cells using excel formula. And how to count the total words in a range of cell with VBA Code. Count the… read more »
