Excel Formulas Archives - Page 65 of 112

How to Combine Data from Multiple Sheets in Excel (4 Ways)

Jun 27, 2024

We have several students along with their Student ID and their Marks, where each sheet contains values for a different subject. We'll consolidate the ...

How to Combine Data from Multiple Sheets in Excel (4 Ways)

How to Keep Formatting in Excel When Referencing Cells – 2 Methods

Aug 9, 2024

The sample dataset contains two columns with names and ages. The header and data have different cell colors. Method 1 - Keeping the Format ...

How to Keep Formatting in Excel When Referencing Cells – 2 Methods

How to Use INDEX MATCH with Multiple Criteria for Date Range

Apr 20, 2024

Let’s say we have certain products whose prices have remained stable for a certain period of time. We want to INDEX MATCH the prices for the given ...

How to Use INDEX MATCH with Multiple Criteria for Date Range

How to Return Row Number of a Cell Match in Excel (7 Methods)

Apr 11, 2024

If you're working with huge datasets and extensive search functions, you might need to locate a specific row to find additional information for a ...

How to Return Row Number of a Cell Match in Excel (7 Methods)

How to Convert Date to Year in Excel (3 Methods)

Jul 28, 2024

Dataset Overview We'll use the list of dates below to convert to year. Method 1 - Convert Date to Year Using Excel YEAR Function ...

How to Convert Date to Year in Excel (3 Methods)

How to Convert Date to Day of Week in Excel (8 Methods)

Aug 4, 2024

02/04/2022 represents a date, it does not provide any information on the day of the week. We will convert that value to the day of the week. ...

How to Convert Date to Day of Week in Excel (8 Methods)

Using the INDEX-MATCH Function with Multiple Criteria for a Partial Text in Excel – 2 Methods

Aug 3, 2024

The Excel INDEX Function The INDEX function returns the value of a cell at the intersection of a row and column in an array or range. Syntax ...

Using the INDEX-MATCH Function with Multiple Criteria for a Partial Text in Excel – 2 Methods

How to Merge Data from Multiple Workbooks in Excel (5 Methods)

Aug 2, 2024

We’ll use the following dataset that represents some salespersons’ sales in different regions. We’ll use two more workbooks, which also represent ...

How to Merge Data from Multiple Workbooks in Excel (5 Methods)

How to Use a Formula to Find Bold Text in Excel (4 Methods)

Jul 24, 2024

Dataset Overview We'll use a dataset that holds products sold on certain days. The products that have sold a Quantity of more than 50 (>50) are ...

How to Use a Formula to Find Bold Text in Excel (4 Methods)

How to Copy a Cell to Another Sheet in Excel If the Cell Contains Text

May 10, 2024

The following dataset contains records of product codes, product lists, salesperson’s names, and corresponding sales values for a company. Using this ...

How to Copy a Cell to Another Sheet in Excel If the Cell Contains Text

If Cell Contains Text Then Add Text in Another Cell in Excel: 6 Ways

Apr 16, 2024

To explain detecting and adding text to cells, let's use a sample dataset containing ID, Product Name, and Size. Method 1 - If ...

If Cell Contains Text Then Add Text in Another Cell in Excel: 6 Ways

How to Find the Last Non-Blank Cell in a Row in Excel (5 Methods)

Jul 27, 2024

Dataset Overview We'll use the below Dataset containing Employee Names and Working Hours. Method 1 - Using Excel LOOKUP Function The ...

How to Find the Last Non-Blank Cell in a Row in Excel (5 Methods)

How to Convert Date to Day of Year in Excel: 4 Methods

Jul 5, 2024

Method 1 - Convert Date to Nth Day of Year Using Excel DATE and YEAR Functions Step 1: An additional column beside the range. Inserting the formula ...

How to Convert Date to Day of Year in Excel: 4 Methods

Compare Two Cells in Excel and Return TRUE or FALSE (5 Quick Ways)

Jun 24, 2024

Let’s consider a dataset (B5:D10) containing fruit names in two columns (columns B and C). We will compare fruit names between these columns and ...

Compare Two Cells in Excel and Return TRUE or FALSE (5 Quick Ways)

How to Find a Character in String from Right in Excel (4 Methods)

May 16, 2024

The sample dataset contains information for a group of people who work in an office and have their own ID and User ID. Method 1 - Using ...