Excel Formulas Archives - Page 69 of 112

Calculate Years and Months between Two Dates in Excel

Jun 16, 2024

To calculate years and months between two dates we are going to use this dataset. It contains some start dates and end dates, and we'll get the ...

Calculate Years and Months between Two Dates in Excel

How to Combine Two Cells in Excel with a Dash (5 Methods)

Jun 19, 2024

Let's consider a scenario where a car dealer gives its cars code with this format: Car Model-Year. We have taken a dataset consisting of Car Model, ...

How to Combine Two Cells in Excel with a Dash (5 Methods)

Excel Formula to Compare Two Cells in Different Sheets: 4 Methods

Jun 5, 2024

Method 1 - Applying Excel Formula to Compare Two Cells in Different Sheets Enter the following formula in cell D5 in Sheet1. Then use the fill ...

Excel Formula to Compare Two Cells in Different Sheets: 4 Methods

How to Count Repeated Words in Excel (11 Methods)

Jun 14, 2024

We have a dataset of some people with their favorite fruits. We are going to use this as the sample dataset all through the article. ...

How to Count Repeated Words in Excel (11 Methods)

[Fixed!] VALUE Error (#VALUE!) When Subtracting Time in Excel

Jul 5, 2024

We used a simple subtraction formula to get the difference between time data. The formula we have used is: =C5-B5 Reason 1 - Excel ...

[Fixed!] VALUE Error (#VALUE!) When Subtracting Time in Excel

How to Reference Cell by Row and Column Number in Excel (4 Methods)

Apr 30, 2024

This article will show you four ways to reference a cell by row and column number in Excel with sharp steps and vivid illustrations. In the following ...

How to Reference Cell by Row and Column Number in Excel (4 Methods)

How to Count the Order of Occurrence of Duplicates in Excel (4 Methods)

Jul 21, 2024

Method 1 - Use COUNTIF Function This method allows you to count the order of occurrence of any type of values in Excel cells, such as text or ...

How to Count the Order of Occurrence of Duplicates in Excel (4 Methods)

How to Use Cell Value as Worksheet Name in Formula Reference in Excel

Apr 25, 2024

Here, we have 3 worksheets—January, February, and March—containing the sales records of these 3 months for different products. We will use cell ...

How to Use Cell Value as Worksheet Name in Formula Reference in Excel

How to Count Cells with Specific Text and Fill/Font Color in Excel (4 Ways)

May 8, 2024

In the dataset below, we have two columns: Book Name and Status. To the right, we have a separate column that will display cell count. Method 1 ...

How to Count Cells with Specific Text and Fill/Font Color in Excel (4 Ways)

How to Count Only Visible Cells in Excel (5 Tricks)

Apr 23, 2024

Usually, we can use the COUNTA function to get the count of existing rows in a dataset. However, when rows are hidden manually or through applying ...

How to Count Only Visible Cells in Excel (5 Tricks)

[Fixed!] Relative Cell Reference Not Working in Excel

Aug 6, 2024

In this article, we will discuss the possible reasons and solutions for relative cell references not working in Excel. What is Relative Cell ...

[Fixed!] Relative Cell Reference Not Working in Excel

Formula to Copy Cell Value and Format in Excel (5 Ways)

May 21, 2024

In this sample dataset, the Name values are in Text format, Weekly Income is in Currency Format and other cells are formatted with text and cell ...

Formula to Copy Cell Value and Format in Excel (5 Ways)

How to Format Cell Based on Formula in Excel (13 Useful Examples)

May 8, 2024

The following dataset represents the Devices of several Brands, Models, and Prices of those Devices. We will use it to demonstrate how to format ...

How to Format Cell Based on Formula in Excel (13 Useful Examples)

How to Remove Blanks from List Using Formula in Excel (4 Methods)

Jul 27, 2024

Scenario Let’s consider a scenario where we have an Excel worksheet containing a list of various computer hardware and accessories. Unfortunately, ...

How to Remove Blanks from List Using Formula in Excel (4 Methods)

How to Convert Degrees Decimal Minutes to Decimal Degrees in Excel

Jul 26, 2024

Calculation for Converting Degrees Decimal Minutes to Decimal Degrees 60 minutes is equal to one degree: 1° = 60' 1/60 degrees equals one ...