Count cells which are not equal to many things in excel

In this article, we will learn about how to Count cells which are not equal to many things in Excel. In simple words, consider a scenario in which ...

Why #REF! occur And How to Fix #REF! in Excel

In this article we will learn about why #REF! occur And How to Fix #REF! in Excel. In excel, at times we get #REF! error. This error occurs when ther...

Validate text which contain specific substring using data validation excel

In this article, we will learn How to validate text entries which contain specific substring using data validation in excel 2016. Data validation too...

How to use the IMSQRT Function in Excel

In this article, we will learn about how to use the IMSQRT function in Excel.  COMPLEX number (inumber) in excel derived for mathematical number h...

Validate dates within next 7 days in data validation excel

In this article, we will learn How to Validate dates within the next 7 days using data validation in Excel 2016. Data validation tool restricts the u...

How to use VBA Collections in Excel

A Collection is a data type that holds stores objects just like arrays (but different). While writing basic VBA codes, you must have used Workbooks,...

Longest Toss winning streak

In this article, we will learn how to get the Longest Toss winning streak in Excel. For Instance, you have a large data of a team of a particular s...

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 Google PlusVisit Us On Youtube