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 use the SHEETS function in Excel

In this article, we will learn about how to use the SHEETS function in Excel. SHEETS function in excel is built-in reference function. This function ...

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...

Counting unique entries in a range

In this article, we will learn How to Count unique entries in a range in Excel. What are unique values in range ? Non- repeating values are ...

Dividing an Amount into Equal Payments While Avoiding Division / Rounding Errors

Problem: The price in cell B1 must be divided accurately into 5 similar payments. When simply dividing the price $48.04 by 5 and rounding the resu...

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