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

Placing the Previous Payment Date beside Each Pay Date in a List

Problem: Columns A & B contain Client ID's and their recent payment dates. We want to add the date of the previous payment from the same clien...

Repeat entries in a column

If you have entries like these in a column which need to be repeated a certain number of times (for e.g. 4 times), try the formula given below the tab...

Rounding Numbers that Meet Specified Criteria

Problem: Rounding all the numbers in column A to zero decimal places, except for those that have "5" in the first decimal place. Solution: Us...

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