Find if a character is in a range in Microsoft Excel

Microsoft Excel is a very vast tool that maintains the data and prepares it as per the requirement. It is used on a very large scale, and we can use i...

Find if a character is in a cell in Microsoft Excel

Sometimes, we struggle to find the special character or special text in the large data of Excel. In this article, we will learn how easily we can find...

Submit a Tip

Have a favorite Microsoft Excel tip that you would like to share?If you have a tip that you believe will be of interest to the visitors of our site, p...

Vlookup Formula – Organizing the Data Table

Rules for organizing the data table for proper use of the Vlookup formula: The Vlookup formula searches for the lookup criteria in the leftmost col...

Finding the First Value in a Row and Retrieving the Header for That Column

Problem: Columns B:G contain the monthly payments for the first half of the year that were made for each investment in column A. The payments for ...

Retrieve the Distance between Any Two Cities from Distance Table

Problem: Range A1:G7 contains a table of the respective distances (miles) between 6 cities. We want to use that table to retrieve the distance bet...

Retrieving Every Nth Value in a Range

In this article, we will learn how to retrieve every nth value in a range. We will use Index function with Row function. Why and how we use Index and...

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