Excel Functions

How to Use VLOOKUP Function on Multiple Rows in Excel

Looking for ways to use the VLOOKUP function on multiple rows in Excel? Do not worry, we are here for you. In this article, we will extensively ...

How to Calculate Bacterial Growth Rate in Excel (2 Easy Ways)

Ways to calculate bacteria growth rate in Excel requires a basic Exponential Formula depending on its characteristics. However, plotting the bacteria ...

How to Find Second Match with VLOOKUP in Excel (2 Simple Methods)

Finding specific cell values manually from a range in Excel datasheets is a really inconvenient process. This article will show you the simple ...

How to Apply VLOOKUP by Date in Excel

We use VLOOKUP by date to find dates in a data table. It is very useful to find the values corresponding to particular dates from a dataset. The ...

How to Remove Vlookup Formula in Excel (6 Methods)

VLOOKUP is one of the most significant functions of Microsoft Excel. We use this function to look up any object from a table or a range. An Excel ...

How to Use VLOOKUP to Find Approximate Match for Text in Excel

In this tutorial, I will discuss several ways to find a partial match in text using Excel VLOOKUP approximate match. We all know that the VLOOKUP ...

How to Use ‘Column Index Number’ Effectively in Excel VLOOKUP

Brief Description of the VLOOKUP Function In the below example, there is a movie dataset. Here, we used the VLOOKUP formula to extract data. ...

How to Use VLOOKUP with Multiple Criteria Including a Date Range: 2 Examples

The following dataset will be used. The dataset contains prices of three different products during 3 quarters of the year 2021. From this ...

51 Mostly Used Math and Trig Functions in Excel

The Math & Trig functions in Excel are very common in many mathematical calculations like- basic arithmetic, conditional sum & product, ...

How to Trim Spaces in Excel (8 Easy Methods)

Let's use a sample dataset that represents the personal information of a particular person. The dataset has 3 columns these are Name, City, and Zip ...

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 ...

Excel COUNTIFS Not Working (7 Causes with Solutions)

Excel COUNTIFS function counts values that match one or more criteria from a range. You may sometimes face the issue that the function is not ...

COUNTIF vs COUNTIFS in Excel (4 Examples)

COUNTIF vs COUNTIFS is a key phrase to differentiate between two functions; COUNTIF and COUNTIFS. The COUNTIF function is a Statistical function that ...

[Fix] TRIM Function Not Working in Excel: 2 Solutions

Microsoft Excel has a myriad of useful Excel functions, one of which is the Excel TRIM function, which makes work easier for users. However, in many ...

How to Count Rows with Formula in Excel?

In this tutorial, I will explain some methods to count the number of rows using Excel Formula.  Usually, we can get the row count by simply clicking ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo