Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

MIN Function

How to Add Blank Space Using Excel Formula (6 Methods)

Sometimes while working with Excel you might need to add blank space before and after the cell values. You might need to add the blank spaces to ...

How to Illustrate Relative Frequency Distribution in Excel

The Relative Frequency Distribution in Excel is a phenomenon where any numerical values symbolize the density of the occurred values within a range. ...

44 Mathematical Functions in Excel (Download Free PDF)

Microsoft Excel has plenty of mathematical functions that help perform various mathematical operations. In this article, you will get to know 44 ...

How to Make an Amortization Table in Excel (4 Methods)

This article shows how to make an Amortization table in Excel that shows the periodic payments on a loan over a period of time. This table breaks ...

How to Use COUNTIF with SUBTOTAL in Excel (2 Methods)

In this article, we’ll illustrate how to use the COUNTIF function with the SUBTOTAL function in Excel to count filtered data using two convenience ...

How to Use Excel INDIRECT Range (8 Easiest Ways)

The INDIRECT function (a Lookup & Reference function) is used to return the reference specified by the text string. This function is used to get ...

How to Use AGGREGATE Function in Excel (13 Examples)

In Excel, the AGGREGATE function is used on different functions to get specific results. In this article, we will show you how to use the AGGREGATE ...

How to Use Type Function in Excel (8 Examples)

The TYPE function in Excel will return an integer number based on the type of data that you are entering. In this article, you will be able to know ...

Statistical Comparison of Two Data Sets Excel

In this article, I will discuss the statistical comparison of two data sets in Excel. At times, while working with spreadsheets, we have to compare ...

VBA to Remove Formulas in Excel Keeping Values and Formatting

In this article, I’ll show you how you can remove formulas from a worksheet in Excel keeping the values and formatting with VBA. First, you’ll learn ...

Excel Find Last Column With Data (4 Quick Ways)

In a large worksheet, finding the last column with data manually is time-consuming and not friendly. There are some functions by using which you can ...

Does TABLE Function Exist in Excel?

In Microsoft Excel, a Table is a tremendously instrumental tool to process large amounts of data with ease. It saves a lot of time and reduces a lot ...

How to Add Space Between Text in a Cell in Excel (4 Easy Ways)

It is a common phenomenon in Excel that we import data from external sources. By doing so, we encounter entries void of spaces. In this article, we ...

How to Return Multiple Values with VLOOKUP in Excel (8 Ways)

Whenever we need to pull a value from another worksheet or within the same worksheet, we can't help but think of the VLOOKUP function in Excel. But ...

Excel INDEX MATCH If Cell Contains Text

If the cell contains the text we can use the combination of INDEX & MATCH functions to perform a smart and advanced lookup. It’s a very popular ...

ExcelDemy
Logo