Validating Data To Be Unique In Excel Range

What is Data Validation tool and how to use it to validate only unique values? Data validation tool restricts the user to input data to ensure its ...

Sorting Numbers Based on their Frequency within a List

In this article, we will learn how to sort the numbers based on their frequency in the range. We use Frequency to know how often a value is repeating...

IFNA function in Excel

In this article, we will learn about the IFNA function. IFNA is a built-in function in Excel. It is categorized as a Logical Function on logic_test...

Determining Divisibility

Problem: Determining whether each of the numbers listed in column A is divisible by the corresponding number in column B. Solution: Use the I...

Counting Number of Cells in a Excel Substring

Problem: Is there any substring function which will count the number of cells containing specific substring.   Solution: To find the ...

How to use the NUMBERVALUE function in Excel

In this article, we will learn about how to use the NUMBERVALUE function in Excel to extract number out of a given input text value using the specif...

PHI function

PHI Function Excel 2013 has given us a new function i.e., PHI. PHI function returns the value of the density function for a standard normal dist...

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