Excel IF

How to Auto Fill Formula When Inserting New Rows/Data in Excel

Sometimes we create a table with formula applied to specific column. And when we editing the table, for example inserting a new row with data into the table, we want the new data lists in the specific column is also applied with this formula as well. Normally we can drag down the upper cell applied… read more »

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 Count the Average Between Two Dates in Excel

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 »

How to Calculate the Median in Different Cases in Excel

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 »

How to Hide Zero (0) Values in Excel

Sometimes we want to find all zero value cells in worksheet and hide zero value to make the data to be checked easier. In this article, we will provide you some simple ways like changing format settings or by IF function to hide zero values. Prepare a table with some 0 value cells. At the… read more »

How to Count Only Unique Values Excluding Duplicates in Excel

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 »

How to Enter\Fill Special Texts into Blank Cells in Excel

Sometimes we open an excel file and find there are some blank cells in the worksheet. We want to mark them with special texts so that readers can find them easily and ignore them. From this article, we will provide you two ways to enter special texts into blank cell to mark them different with… read more »

How To Align Duplicate Values within Two Columns in Excel

This post will guide you how to align duplicate values within two columns based on the first column in your worksheet in Excel. How do I use an formula to align two columns duplicate values in Excel. Aligning Duplicate Values in Two Columns Assuming that you have two columns including product names in your worksheet…. read more »

How To Split Columns to Seprated Negative and Positive Values in Excel

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 »