In this article, we will learn How to Count unique entries in a range in Excel. What are unique values in range ? Non- repeating values are ...
As I have mentioned in many of my blogs that a SUMPRODUCT is a very versatile function and can be used for multiple purposes. In this article, we ...
In this article, we will learn Calculating the Average for Numbers Meeting Specified Criteria in Excel. Scenario: When working with data, wh...
In this article, we will learn How to round off Calculation of Retail Price and Sales Tax in Excel. How to round off with retail price and sale...
Problem: Converting the full names in column A, formatted "LastName, FirstName" into names formatted "FirstName LastName". Solution: Use the ...
Problem: We want to retrieve all the numbers from List1 (column A) that are greater than the number specified in cell B2. Solution: Use the I...
In this article, we will learn how to use Rank function in Microsoft Excel and where we need to use it in data. We use Rank formula to return ranking...
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
