In this article, we will learn How to validate time entries which contain specific hours, specific minutes or specific time using data validation in...
In this article, we will learn how to validate data entries that must contain specific year, specific month or specific date using data validation i...
In any department of any organization, Excel plays an integral part of data management, analysis, representation, etc. Be it the owner of an MNC or a ...
In this article, we will learn how to validate only uppercase text entries in Excel 2016. Problem: Here we have a task where only uppercase ...
Sometimes we want our sheets to be view only. We don't want the user to make any change to some specific sheet. In that case, we should protect or say...
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...
Introduction to VLOOKUP Function The VLOOKUP function in Excel is without a doubt, is the most used and talked function. In any job interview that r...
In the VLOOKUP function, we often define col_index_no static. We hardcode it within the VLOOKUP formula, like VLOOKUP(id,data,3,0). The problem aris...
In this article, we will learn How to use the ISBLANK function in Excel. What is the ISBLANK function ? The ISBLANK function is a logical op...
Hi There! Imagine you have thousands of rows of data of employees in Excel, and your boss randomly asks you the salary and designation of Ramesh. ...
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.
