How to Outline Index numbering in Excel

In this article, we will learn How to Outline Index numbering in Excel Scenario: In simple words, while working with the index values in a d...

Count cells if starts with a, b or c in range in Excel

In this article, we will learn how to Check values which start with either A, B or C using wildcards in Excel. In simple words, while working with ta...

Lookup in 2d table using INDEX & MATCH function

In this article, we will learn how to look up values in 2d table using an INDEX-MATCH-MATCH function in Excel. Scenario: Assume that you nee...

How to Count Dates of Given Year

In this article, we will learn how to count dates of a particular year in a range of dates. In simple words, while working with dates, sometime...

How to Count Rows With Criteria Using SUMPRODUCT

In this article, we will learn how to count rows with criteria SUMPRODUCT in Excel. Scenario: In simple words, while working data, sometimes w...

How to Count Cells that End With Specific Text

In this article, we will learn how to count values which end with certain text in Excel. We will try to get the count of values that end with a gi...

Count valid numbers in list

In this article, we will learn about how to count valid numbers in list in Excel. At Instance, we need to calculate the occurrence of some values 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 Youtube