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 »
If we want to calculate the average for all numbers from multiple worksheets, how can we do calculate? Currently we may know the way to calculate the average for a selected range on one worksheet, this article will introduce you a convenient way to calculate the average for all numbers across multiple worksheets. As the… 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 use VLOOKUP function to find proper value by certain conditions in excel. And we often create a dropdown list to filter value in excel. If you combine these two features together, it can help us solve a lot of search problems by some conditions, and it will bring us a lot of convenience…. read more »
In our daily work, we usually have the problem of counting the average of a period. If the given dates are continuous, we can handle this situation very well, and if the dates are discontinuous, how do we count the average for different periods? In this article, we will use some examples to show you… read more »
Sometimes we want to convert date and time format to date only format in excel for example convert 01/29/2019 06:51:03 to 01/29/2019, we can convert format by Formula or Format Settings. The two ways are easy to learn, so you can select one you like to convert date and time format. Convert Date & Time… read more »
The median is the number in the middle of a range of data by order, half of the data in this range is larger than it, and half is smaller than it. Sometimes we want to calculate the median for a range of data. This article will introduce you the formula to calculate the median… read more »
We enter a list of numbers or products and there are some duplicates in the list, if we want to just do count for the unique values and exclude the duplicates, how can we do? Now you can follow the below steps to solve this question by formula quickly. Prepare a list of products and… read more »
We often use Sum function to calculate the total amount of a column. If #N/A exists in the column, how can we ignore them and just calculate the numbers in the column. This article will show you the simple method to do count ignore the invalid #N/A. First prepare a list of number contains #N/A… read more »
This post will guide you how to separate negative numbers and positive numbers from a column into two columns with a formula in Excel. How do I split numbers into two columns with negative and positive numbers in Excel. Splitting Columns to Separated Positive and Negative Numbers Assuming that you have a list of data… read more »
