How to remove duplicates in Excel

How to remove duplicates in Excel

One of the essential tasks when cleaning up a data set is getting rid of duplicate values. In this article, we’re going to show you  how to remove duplicates in Excel using the Remove Duplicates feature. To find duplicate values using a formula please see: How...
How to find nth largest value in a data table

How to find nth largest value in a data table

This article shows you that how to find nth largest value by using the LARGE function. Syntax =LARGE(absolute data range reference, nth) Steps Start with =LARGE( function Select the range that contains the values $B$2:$G$7, Select the cell that contains nth value or...
How to calculate percentage in Excel

How to calculate percentage in Excel

A percentage is a number or ratio that represents a fraction of 100, and this representation is used widely from interest rates to risk analysis, or really in any application when the contribution of a specific item to the whole is to be highlighted. In this article,...