Excel Formulas Archives - Page 96 of 149

How to Split Data in Excel – 5 Methods

Aug 3, 2024

The following dataset showcases full names and first and second names. Method 1 - Using Text to Columns Features to Split Data in Excel ...

How to Keep a Running Balance in Excel (8 Methods)

Jun 9, 2024

We've put daily Earnings and Expenses in the first week of February 2022 in our sample dataset. We'll use it to track expenses. How to ...

How to Keep a Running Balance in Excel (8 Methods)

How to Find External Links in Conditional Formatting in Excel (2 Ways)

Nov 11, 2025

Assume your worksheet contains a large number of external links, and you now have to dynamically identify the cells that contain the links and ...

How to Find External Links in Conditional Formatting in Excel (2 Ways)

Excel Macro to Split Data into Multiple Files: 2 Methods

May 28, 2024

Method 1 - Steps to Create the Excel Macro to Split Data into Multiple Files Open the VBA Editor in Excel Press ALT+F11 to open the VBA editor ...

Excel Macro to Split Data into Multiple Files: 2 Methods

Calculate Debit Credit Running Balance Using Excel Formula (3 Examples)

Jun 28, 2024

We'll use the following dataset, where deposits and withdrawals on the credit and debit accounts are put in column C and column D. We’ll calculate ...

Calculate Debit Credit Running Balance Using Excel Formula (3 Examples)

How to Find Max Value in Range with Excel Formula: 5 Easy Methods

Jun 21, 2024

Method 1 - Applying Excel MAX Formula to Find Maximum Value in Range Steps: Type the below formula in Cell B15 and press Enter from the ...

How to Find Max Value in Range with Excel Formula: 5 Easy Methods

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)

Get the First Day of the Current Month in Excel (3 Methods)

Nov 11, 2025

Microsoft Excel offers a handful of methods to get the first day of the current month. You can also get the first day of any random month or for the ...

Get the First Day of the Current Month in Excel (3 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 ...