Excel Formulas Archives - Page 57 of 112

How to Create an Auto Ranking Table in Excel (with Quick Steps)

Jul 5, 2024

Method 1 - Create an Auto Ranking Table for Ascending Order ❶ Insert the following formula in cell D5. =RANK.EQ(C5,$C$5:$C$14,1) ❷ Press ...

How to Create an Auto Ranking Table in Excel (with Quick Steps)

How to Split Text after a Certain Word in Excel (7 Ways)

May 21, 2024

To illustrate how to split text after a certain word in Excel, we’ll use the following dataset as an example. Method 1 - Combining LEFT and ...

How to Split Text after a Certain Word in Excel (7 Ways)

How to Subtract Multiple Cells in Excel (6 Effective Methods)

Jul 5, 2024

The following sample dataset contains Id No, Name, Salary, House Rent, Grocery and Bill columns. We will use 6 methods to subtract multiple cells ...

How to Subtract Multiple Cells in Excel (6 Effective Methods)

How to Split Text by Space with Formula in Excel (5 Ways)

Jun 13, 2024

We have a sample dataset containing Names. Space is used as a delimiter here. Let's split the text using formulas in Excel. Method 1 - ...

How to Split Text by Space with Formula in Excel (5 Ways)

How to Sum Columns by Color in Excel (6 Easy Methods)

May 13, 2024

The below dataset contains several items sold in quantity. Different fill colors have been applied to the Sold Quantity column. Method 1 – Using ...

How to Sum Columns by Color in Excel (6 Easy Methods)

Subtraction for Whole Column in Excel (with 5 Examples)

Jul 5, 2024

Below is a dataset that includes income and expenses. Method 1 - Subtraction of Cells Between Two Columns in Excel Steps ...

Subtraction for Whole Column in Excel (with 5 Examples)

How to Separate Date in Excel Using Formulas (5 Methods)

Jul 28, 2024

Dataset Overview For this demonstration, we’ll be utilizing the dataset provided below. In the range of cells from B5 to B10 on the left, you’ll ...

How to Separate Date in Excel Using Formulas (5 Methods)

How to Sum Filtered Cells in Excel (5 Suitable Ways)

Jun 23, 2024

Download the Practice Workbook Sum Filtered Cells.xlsm 5 Easy Methods to Sum Filtered Cells in Excel Let's consider a ...

How to Sum Filtered Cells in Excel (5 Suitable Ways)

How to Sum Selected Cells in Excel (4 Easy Methods)

Jun 25, 2024

Method 1 - Using the SUM Function to Sum Selected Cells in Excel The following dataset shows sales for different months for a company. We'll ...

How to Sum Selected Cells in Excel (4 Easy Methods)

How to Subtract from Different Sheets in Excel: 2 Suitable Methods

Jul 5, 2024

Method 1 - Using Manual Formula to Subtract from Different Sheets Steps: Go to the spreadsheet where you want to find the subtraction of the ...

How to Subtract from Different Sheets in Excel: 2 Suitable Methods

How to Calculate YTD (Year-To-Date) Average in Excel (4 Approaches)

Jul 5, 2024

Method 1 - Calculate YTD Average Using Excel AVERAGE Function For calculating the year-to-date average, we are going to use the following dataset. ...

How to Calculate YTD (Year-To-Date) Average in Excel (4 Approaches)

How to Split Date and Time in Excel (8 Easy Methods)

Jul 1, 2024

Method 1 - Using the INT Function to Split Date and Time in Excel We have a dataset containing the date and time. We'll split them in Columns C and ...

How to Split Date and Time in Excel (8 Easy Methods)

Split Column in Excel by Word (5 Effective Ways)

Jun 12, 2024

Suppose we have a list of addresses in a column as shown below. Each cell of the column contains the word SUITE. Let's split the column by that word. ...

Split Column in Excel by Word (5 Effective Ways)

How to Split Names Using Formula in Excel: 5 Easy Methods

May 29, 2024

Method 1 - Extract First Name Steps Select cell C5 where you want to apply the formula to extract the first name. Write down the ...

How to Split Names Using Formula in Excel: 5 Easy Methods

How to Split Names with Comma in Excel: 3 Suitable Methods

May 23, 2024

Method 1 - Split Names with Comma Using Text to Columns in Excel Steps: Select all the cells containing cells separated by a comma. In this ...