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

Circular Reference in Microsoft Excel

In this article, we will learn about circular reference. Circular reference can be a formula that refers to its own cell value, or refers to a cell d...

Displaying Formula Syntax in Excel 2007

To display and print the formula in a file, we can use the Ctrl+`, (`) the sign is located to the left ofthe number 1 on your keyboard. Let’s tak...

How to find the minimum value in range while ignoring 0 value in Microsoft Excel

To find the minimum numerical value in range while ignoring the 0 value, we can use the Small function along with Countif function in Microsoft Excel....

Find the minimum numerical value in a list based on a criteria in Excel 2010

To find the minimum numerical value in a list, based on a criteria, we can use the MIN function along with the If function in Excel 2010. MIN: This...

Find Duplicates Items in Combine Columns in Microsoft Excel

In this article we will learn how to find the duplicate items in combined columns. To find duplicate items we use the “COUNTIF” and “IF” form...

How to Calculate VAT in Excel

In this article you will learn how to calculate VAT in Excel by using a functions? And Which formula we can use to calculate how much VAT has been pai...

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