Defining a Range Name in Microsoft Excel 2010

In this article, we will learn how we can define a range name in Microsoft Excel 2010. There are two techniques to define a range name. Let’s tak...

Find the Last Value in Column in Microsoft Excel

In this article, we will learn how to find the last numeric value in a range. We can use the “Index” function along with “Match” function in M...

Pasting Values in Microsoft Excel 2010

In this article, we will learn how to paste the cell values by using the Paste Special function or how we can write the VBA code in Microsoft Excel 20...

Count the Number of Values between a Lower and Upper Limit in Microsoft Excel

In this article, we will learn how to count the number of values between a lower and upper limit. We will use “SUMPRODUCT” function in Microsoft E...

Counting Rows that Match Specific Criteria for Each Column in Microsoft Excel 2010

In this article, we will learn how to count rows that match specific criteria for each column. If you want to count the rows that match specific cr...

Creating New IP Addresses In Excel 2010

In this article, we will learn how to create new IP address. If you want a formula that will generate IP Address, you can use combination of LEFT &...

Determining whether a Person Worked in a Full Or Partial Shift in Excel 2010

In this article, we will learn how to determine whether a person worked a full or partial shift. While preparing attendance report, you want a form...

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