Copy the contents of the previous row to the next row

In this article, we will learn Copy the contents of the previous row to the next row in Excel Types of copy and paste methods in Excel ? In ...

How to Sum Values of Cells Occurring at the Intersection of Ranges Excel

In this article, we will learn How to Sum Values of Cells Occurring at the Intersection of Ranges Excel Scenario: When working with a long d...

Personal Notes or Hidden Text in a Excel Formula

You can use your personal notes in a formula to remember the details of the figures getting calculated there. For example, if a hostel student rece...

Watch Calculation Results Immediately in Excel

In this article, we will learn to Watch Calculation Results Immediately in Excel. What is the status bar and where to find the status bar in Ex...

Disregarding blank cells when performing calculations on a range

Problem: Listed in Range A1:C13 are the totals of sales made by each salesman per date. A blank cell in column E, indicates that no sales were mad...

How to Reverse Strings in Excel

In this article, we will learn How to Reverse Strings in Excel Problem: Converting the full names in column A, formatted "LastName, FirstNam...

Finding the Largest Value from Two Different Lists, Subject to Specified Criteria

Problem: Columns A & B contain two lists of numbers. We want to create a formula that will return the maximum value from either list, providing th...

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.