Calculating the Average for Numbers Meeting Specified Criteria

In this article, we will learn Calculating the Average for Numbers Meeting Specified Criteria in Excel. Scenario: When working with data, wh...

Rounding the Calculation of Retail Price and Sales Tax

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...

Reversing Strings

Problem: Converting the full names in column A, formatted "LastName, FirstName" into names formatted "FirstName LastName". Solution: Use the ...

Retrieving Values from a List that are Greater than a Specified Number

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...

Ranking a List of Numbers

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...

How to Retrieve a value from a reference grid according to index values Save in Excel

In this article, we will learn How to Retrieve a value from a reference grid according to index values Save in Excel Scenario : Many times w...

GAMMA function

GAMMA function has been introduced with Excel 2013. This function returns the Gamma function value.   Syntax:- =GAMMA (number) &nb...

Terms and Conditions of use

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube