How to Use Wildcard with Vlookup in Microsoft Excel

In case you have not use Vlookup with wildcard then this article is for you & you will really wonder how easy your life would be after you learn t...

Multi Conditional Vlookup in Excel

Vlookup function in Excel is one of the most used functions. In this article, we will learn how to use Vlookup with multiple criteria.   Question: ...

Finding the Maximal/ Minimal String, Based on Alphabetic Order in Microsoft Excel 2010

In this article, we will learn how to find the maximal or minimal string, based on alphabetic order to retrieve the minimal or maximal values from a f...

Retrieving the Value of the First Non-Blank Cell in a List in Microsoft Excel 2010

In this article, we will learn how to retrieve the value of the first Non-Blank cell. We use the Index function along with Match function in Microsoft...

Retrieving the Nth Value in a Row, Column and Range in Microsoft Excel 2010

In this article, we will learn how to retrieve the Nth value in a Row, Column, and range. We use a combination of “OFFSET”, “Index”, and “RO...

Retrieving the Minimal / Maximal Values from a Filtered List in Microsoft Excel 2010

In this article, we will learn how to retrieve the minimal or maximal values from a filtered list. We will use the Subtotal function in Microsoft Exce...

Retrieving the Last Value and the Last Character in a Row in Microsoft Excel 2010

To retrieve the last value, we use a combination of “INDEX”, “MAX”, and “COLUMN” functions, and to retrieve the last character in a row, w...

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