Excel Formulas Archives - Page 92 of 149

How to Merge Rows with Commas in Excel (4 Methods)

Jul 21, 2024

Dataset Overview To explain the methods, we will use a dataset that contains information about the Department and the Age of some employees of a ...

How to Merge Rows with Commas in Excel (4 Methods)

How to Make Multiplication Table in Excel (4 Methods)

Nov 11, 2025

If you are looking for some special tricks to make a multiplication table in Excel, you've come to the right place. There are numerous ways to make a ...

How to Make Multiplication Table in Excel (4 Methods)

How to create a Hyperlink to a Cell in Another Sheet with VLOOKUP Function – 3 Steps

Aug 13, 2024

This is an overview: The Excel HYPERLINK Function Function Objective: The HYPERLINK function in Excel creates a shortcut or link that ...

How to create a Hyperlink to a Cell in Another Sheet with VLOOKUP Function – 3 Steps

How to Use the INDEX and the MATCH Functions in Excel – 14 Examples

Aug 4, 2024

This is an overview. The INDEX and the MATCH Functions in Excel The INDEX function returns a value or a reference to a ...

How to Use the INDEX and the MATCH Functions in Excel – 14 Examples

How to Extract Text After First Space in Excel (3 Suitable Ways)

Apr 30, 2024

This guide will use the sample dataset pictured below. Method 1 – Merging MID Function With FIND Function to Extract Text After the First ...

How to Extract Text After First Space in Excel (3 Suitable Ways)

[Fixed!] INDEX MATCH Not Returning Correct Value in Excel (5 Reasons)

May 25, 2024

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

[Fixed!] INDEX MATCH Not Returning Correct Value in Excel (5 Reasons)

How to Sum Columns in Excel When Filtered (7 Ways)

May 12, 2024

Consider the following dataset for demonstrating how to sum columns. We have Components, Manufacturer, Country of Manufacture, Quantity, Unit Price, ...

How to Sum Columns in Excel When Filtered (7 Ways)

How to Sum Columns in Excel Table: 7 Methods

May 19, 2024

Method 1 - Use of AutoSum Function to Sum Columns in Excel Table Steps: Select the entire range of cells B4:E14. Insert tab, select ...

How to Sum Columns in Excel Table: 7 Methods

How to Calculate MTD (Month to Date) in Excel (3 Methods)

Jun 14, 2024

Method 1 - Combine SUM, OFFSET, ROWS & DAY Functions to Calculate MTD in Excel Suppose we have the following dataset of a fruit stall. The ...

How to Calculate MTD (Month to Date) in Excel (3 Methods)

How to Split Comma Separated Values into Rows or Columns in Excel

Jun 28, 2024

Method 1 - Separate Data into Rows/Columns by Comma Using Text to Columns in Excel Case 1.1 - Split Values into Columns We have a dataset ...

How to Split Comma Separated Values into Rows or Columns in Excel

[Fix:] Highlight Duplicates in Excel Not Working

Jul 5, 2024

We have a dataset containing Product Sales on a certain date. We want to find the duplicates in the Product, Quantity, and Unit Price columns. It ...

[Fix:] Highlight Duplicates in Excel Not Working

How to Highlight a Cell in Excel (5 Methods)

Nov 11, 2025

There are several ways to highlight a cell in Excel, among them we will demonstrate to you 5 easy and effective methods. How to Highlight a ...

How to Highlight a Cell in Excel (5 Methods)

How to Highlight from Top to Bottom in Excel (5 Methods)

Nov 11, 2025

In Microsoft Excel, we can highlight top to bottom values with the help of conditional formatting. Highlighting top and bottom values with different ...

How to Highlight from Top to Bottom in Excel (5 Methods)

Excel Split Data into Columns by Comma (7 Methods)

Nov 11, 2025

Excel is the most widely used tool when it comes to dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. ...

Excel Split Data into Columns by Comma (7 Methods)

How to Extract Text between Two Spaces in Excel (5 Easy Ways)

Jul 9, 2024

For illustration, we will extract First Names from the sample dataset shown. Method 1 - Extract Text between Two Spaces Using MID and FIND ...