All Microsoft Excel Versions

Retrieving the Column Header of the Next Non-Blank Cell in a Row in Excel 2010

To retrieve the column header of the next non blank cell in a row, we can use a combination of INDEX, MATCH, MIN, IF & COLUMN functions to get the...

Returning the Entire Contents of the Row Containing the Highest Math Grade

In this article we will learn how to return the entire content of the row containing the highest math grade in Microsoft  Excel 2010. If you want ...

How to Use Index with Match Function in Microsoft Excel 2010

In this article we will learn about how we can find the matching values from not adjacent list, we can use a combination of INDEX & MATCH function...

Retrieving the Most Recent Payment Made by Client

In this article we will learn how we can retrieve the most recent payment made by client in Microsoft Excel. While preparing reports for multiple c...

Retrieving the Player Who Scored the Highest Number of Points in Microsoft Excel 2010

In this article we will learn how we can retrieve the player who scored the highest number of points in Microsoft Excel 2010. To retrieve the name ...

Retrieving from List by Position

To retrieve value from list by position, we will use INDEX function to get the output. What is Index function and how we can use the Index function...

Retrieving the Price for a Specified Item and a Specified Brand in Microsoft Excel 2010

To retrieve the price for a specified item that matches with specified brand, we will use a combination of "IF" & "LOOKUP" functions to get the o...

Retrieving Values Using References Based on Row and Column Numbers in Microsoft Excel 2010

To retrieve the values using references based on row & column numbers, we will use a combination of "INDIRECT"& "ADDRESS" functions to get the...

Retrieving Sale Price Based On Item And Color Criteria in Microsoft Excel 2010

In this article we will learn about how we can recover sale price based on item and color criteria in Microsoft Excel 2010 To retrieve sale price b...

Rounding Numerical Substrings

To find a formula that will retrieve the output by rounding numerical substrings to 3 decimal places, we will use a combination of LEFT, FIND, MID &am...

Page 22 of 105« First...10...2021222324...304050...Last »
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