Retrieving the Value of the First Nonblank Cell in a List

To retrieve the value of the first non blank cell in a list, we will use Index and Match functions. Why and how we use Index and Match functions toge...

Ignoring Blank Cells Containing Invisible Spaces when Using Array Formulas

Problem: Columns A & B contain the number of points scored by a particular player during each quarter of a game. An empty cell indicates that ...

Checking If Matching Numbers Exist in Different Ranges

In this article, you’ll learn how to check if matching numbers exist in different ranges in Microsoft Excel. When we want to pick the values from f...

How to Transpose in Excel?

In this article, we will learn how to switch the row value into column value and column value into row value through Transpose formula in Excel. Pr...

Retrieving List Values that Do Not Appear in a Second List

Problem: We want to create a new list consisting of the values from List1 (column A) that are not common to List2 (column B) as well. Solution: ...

New AVERAGE Functions in Excel 2007

In this article, you’ll learn about the Average functions in Microsoft Excel. Average functions we use when we want to judge the overall group perfo...

Calculating Total Annual Payment Based on Cumulative Monthly Payments

Problem: Column A is a list of several different payments that are due each month. Column B indicates the date that each payment is no longer requi...

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