Excel Countif

How to Find the Smallest Value and Smallest Positive Value in Excel

Sometimes we want to find out the smallest positive value among a set of values. We should ignore the negative value and zero value when getting the smallest positive value. So we design different cases in this article to demonstrate how can we get the smallest positive value by different formulas. Returns the Smallest Value… read more »

How to Filter Data Based on Another List Selection in Excel

We can do filter data by some certain criteria for a list or a table in excel. And if the criteria is another list selection in worksheet, how can we filter data from original selected range refer to the new list selection? This article will provide you two methods to filter data based on another… read more »

How to Sort a Column by Occurrence Count in Excel

This post will guide you how to sort a column by occurrence count in Excel. How do I sort data in one column by the most frequent value in Excel 2013/2016. Sort A Column by Occurrence Count Assuming that you have a list of data in one column, and you want to sort this column… read more »

How to Count or Sum Cells with Checked Box in Excel

This post will guide you how to count the number of checked checkboxes in your worksheet in Excel. How do I Count or sum all cells with checked boxes with a formula in Excel. Count or Sum Cells with Checked Box Assuming that you have a list of data in range A1:C5, in which contain… read more »

How to Count the Number of Cells with non-zero value in Excel

This post will guide you how to count the number of cells with non-zero value with formula in Excel 2013/2016. Count the Number of Cells with non-zero value Assuming that you have a list of data in range A1:C6 which contain text string values. And you want to count the number of cells with non-zero… read more »

How to Count Unique Values in Excel

This post will guide you how to count unique values or distinct values with a formula in Excel. How do I Count unique values or numbers in a given range in Excel. Count Unique Values Using Advanced Filter Count Unique Values Using Formula Assuming that you have a list of data that you want to… read more »

How to Rank Numbers without Repetitive Ranks in Excel

This post will guide you how to rank range numbers with unique ranking in Excel. How do I use Rank function to get the unique ranking of values for a range with duplicate values in Excel 2013/ 2016. Ranking without Repetitive Ranks Assuming that you try to use the RANK function to sort values in… read more »

Sidebar