Excel Data Validation Between Dates

Sometimes we want users to pic dates from specified dates only. Irregular dates makes it hard to analyse data effectively and increase work overhead. ...

How to use Stacked Column Chart in Excel

Stacked chart is good for visualising data as part of whole. They are same as stacked bar chart with only difference of orientation. The stacked bar c...

How to use the BITOR Function in Excel

In this article, we will learn about how to use the BITOR function in Excel.  BITOR function in excel perform the Bitwise OR operation between the t...

How to use the BITAND Function in Excel

In this article, we will learn about how to use the BITAND function in Excel.  BITAND function in excel perform the bitwise AND operation between th...

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

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