Excel Formulas Archives - Page 67 of 112

How to Reference Text in Another Cell in Excel (14 Ways)

Apr 23, 2024

Method 1 - Reference Text from One Cell to Another Cell in the Same Worksheet in Excel Consider the following example. We will take cell B7 and ...

How to Reference Text in Another Cell in Excel (14 Ways)

How to Calculate Average If Within Date Range in Excel (3 Ways)

May 14, 2024

To demonstrate our methods, we'll use a sample dataset containing Date, Region, and Sales. and calculate the average Sales within a certain date ...

How to Calculate Average If Within Date Range in Excel (3 Ways)

How to Convert a Number to Text with the Green Triangle in Excel (6 Methods)

Jul 26, 2024

What Does the Green Triangle Indicator Mean? In case Excel detects an error in its calculation it indicates the error by displaying a triangle on ...

How to Convert a Number to Text with the Green Triangle in Excel (6 Methods)

How to Compare Two Cells and Change Color in Excel (2 Ways)

Apr 30, 2024

We have two different Product lists. The Product lists have products that are ordered on certain days. We want to compare these products on the same ...

How to Compare Two Cells and Change Color in Excel (2 Ways)

How to Combine Rows from Multiple Sheets in Excel (4 Methods)

Jun 21, 2024

Method 1 - Use Consolidate Option to Combine Rows from Multiple Excel Sheets The Consolidate feature is the quickest way to combine rows. But we can ...

How to Combine Rows from Multiple Sheets in Excel (4 Methods)

How to Convert Date to Month and Year in Excel (4 Ways)

Jun 14, 2024

Suppose we have a dataset of several employees with DoB (date of birth) in column C. We want to convert the date to month and year only for ...

How to Convert Date to Month and Year in Excel (4 Ways)

How to Change Date Format in Excel Using Formula

Jun 23, 2024

To change date format using a formula in Excel: Select a cell. Insert the formula: =TEXT(Reference Cell,"Date Format") Press Enter. For ...

How to Change Date Format in Excel Using Formula

How to Convert a Date to dd/mm/yyyy hh:mm:ss Format in Excel

Jul 4, 2024

Method 1 - Change the Default Date & Time Format to dd/mm/yyyy hh:mm:ss in Excel When we add a date in a cell of an Excel worksheet, it stores ...

How to Convert a Date to dd/mm/yyyy hh:mm:ss Format in Excel

How to Get Last Day of Previous Month in Excel (3 Methods)

Jul 5, 2024

The sample dataset contains a list of dates in column B. We'll find the last day of the previous month in column C. Method 1 - ...

How to Get Last Day of Previous Month in Excel (3 Methods)

How to Convert 7 Digit Julian Date to Calendar Date in Excel (3 Ways)

Jul 6, 2024

The date format which uses the combination of a year and the number of days since the start of that year is known as Julian Date format. In the 7 ...

How to Convert 7 Digit Julian Date to Calendar Date in Excel (3 Ways)

How to Find Column Index Number in Excel (2 Methods)

Aug 4, 2024

In this tutorial, we will explain some ways to find the Column Index Number in Excel. We'll use the following dataset containing the Painting ...

How to Find Column Index Number in Excel (2 Methods)

How to Count Unique Values in a Filtered Column in Excel (5 Methods)

Jul 29, 2024

Dataset Overview In our dataset, we have information on the Quantity and Sales of various Product Categories, along with Order Dates and ...

How to Count Unique Values in a Filtered Column in Excel (5 Methods)

How to Calculate First Day of Previous Month in Excel (2 Methods)

Jul 30, 2024

Method 1 - Use the EOMONTH Function to Calculate the First Day of the Previous Month Step 1: Enter the following formula in cell C5. ...

How to Calculate First Day of Previous Month in Excel (2 Methods)

How to Convert Number to Text with Commas in Excel (3 Methods)

Jul 25, 2024

Dataset Overview We will be working with the following dataset to demonstrate these methods. Method 1 - Using FIXED Function The ...

How to Convert Number to Text with Commas in Excel (3 Methods)

How to Change Default Date Format from US to UK in Excel (3 Ways)

Jun 14, 2024

Consider the following dataset which represents five nominated movies in the best picture category for the Acadamy Awards (Oscars) in 2022. At first, ...