How to use the AREAS Function in Excel

In this article, we will learn how to use AREAS Function in Excel. AREAS function is a reference function which returns the count of area referenc...

6 Formulas to Lookup in Excel

We all know the famous star of Excel functions VLOOKUP. It is commonly used for looking up values with a unique Id. But this is not the only function ...

How to Lookup Values Using Excel OFFSET-MATCH Function

The VLOOKUP, HLOOKUP and INDEX-MATCH are famous and common ways to lookup a values in Excel table. But these are not the only ways to lookup value...

Find the partial match number from data in Excel

In this article, we will learn to Find the partial match number from data in Excel. Scenario: In simple words, while working with numbers  ...

Find the last ROW with mixed data in Excel

In this article, we will learn to Find the last ROW with mixed data in Excel. Scenario: In simple words, while working with long unmannered ...

How Lookup Nth Match Using VLOOKUP function

Normally, the VLOOKUP function returns the first match it finds. But the matter gets complicated when there more than one match and we want to get any...

Find the last row of data with numbers in Excel

In this article, we will learn to Find the Last ROW of numbers data in Excel. Scenario: In simple words, while working with long unmannered ...

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