Learn Microsoft Excel Online FreeThis post will guide you how to count unique items in Excel Pivot Table. How do I use Pivot Table to count unique distinct values in Excel. How to get a distinct count in a pivot table in Excel. Assuming that you have a list of 5 cells with 3 unique values, and you want… read more »
This post will guide you how to show only positive values in an excel formula. How to show formula result only if it is a positive value in excel. Is there a way to have a formula return only positive numbers in excel. Show Only Positive Values Assuming that you have a list of data,… read more »
This post will guide you how to compare the adjacent cells in the different columns using Conditional Formatting Icon Sets in Excel. How do I compare cells in the adjacent rows using Conditional Formatting Icon Sets in Excel. How to compare Columns or rows using Conditional Formatting Icon Sets to show increase or decrease status… read more »
This post will guide you how to create a five star rating system in your current worksheet in excel. How do I change the five points system to five star rating in excel. How to use the conditional formatting function to create a five star rating system in excel. Create a Five Star Rating System… read more »
This post will guide you how to find the largest value based on one criteria in excel. How do I return the largest value based on multiple criteria in excel. How to find and return the largest value based on one criteria and multiple criteria with formula in excel. Find Largest Value with multiple Criteria… read more »
This 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 »
