Learn Microsoft Excel Online FreeSometimes 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 »
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 »
We often do statistics analysis by Excel in our daily work, and sometimes we need to count the percentage for different data in a series of data, so that we can see the data distribution of this series of data and we can also find out which data accounts the largest proportion. Due to different… read more »
We often filter data by some criteria in its own worksheet, but if we have two or more worksheets and want to filter data from sheet1 by the criteria in worksheet2 how can we do? If we can filter data by another worksheet, then in our daily work, it will be quite helpful when we… read more »
In general life we usually need to count the number among a range of values based on the criteria ‘greater than a fixed value and less than another value’. We may also need to sum the total values for the matched samples. In this case. we will use COUNTIF and SUMIF function to do the… read more »
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 »
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 »
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 »
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 »
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 »
