How to Use MAX IF Function in Excel (4 Practical Examples)

What Is MAX-IF Formula in Excel? MAX Function The MAX function is one of the most commonly used functions in Excel. It returns the maximum value ...

How to Use Excel IF Function with Range of Values (10 Examples)

Introduction to the IF Function in Excel ⇒ Syntax =IF(logical_test, , ) ⇒ Function Objective Determines if a condition is TRUE or ...

VLOOKUP to Return Multiple Values Horizontally in Excel: 2 Methods

Method 1 - Use of INDEX, SMALL, and IF Functions to VLOOKUP and Return Corresponding Values Horizontally Step 1: ➤ The required formula in cell ...

Find the Max of Multiple Values by Using the VLOOKUP Function in Excel – 2 Methods

Method 1 - Combining the VLOOKUP and the MAX Functions to Find the Max of Multiple Values This is the sample dataset. Steps: Enter the ...

How to Sort Duplicates in Excel – 3 Methods

The following dataset contains duplicate items and quantities in kg. Duplicates were sorted in alphabetical order from A to Z. Quantities were sorted ...

How to Sort Rows by Column in Excel (4 Easy Methods)

Method 1 - Use Ascending (A-Z) or Descending (Z-A) Options to Sort Rows by Column in Excel Method 1.1 - Sort Rows by Column from A-Z (Smallest to ...

How to Perform Random Sort in Excel (6 Easy Methods)

We will show 6 easy methods to random sort in Excel, using a dataset of a shop containing product Name, Quantity, Delivery Date, and Price. ...

How to Perform Custom Sort in Excel – 3 Steps

The sample dataset showcases Names, Marks in Mathematics, and students' Grades. There are 6 different grades. A+, A, A-, B, C, and ...

How to Generate Random Number from List in Excel (4 Ways)

  Method 1 - Using INDEX and RANDBETWEEN Functions to Get a Random Number from a List in Excel In the following picture, Column B has ten ...

How to Sort Rows in Excel (3 Easy Ways)

To demonstrate methods for sorting rows in Excel, we’ll utilize this simple dataset listing several footballers and their goals scored over the last ...

How to Sort by Date in Excel: 9 Suitable Methods

Method 1 - Applying Sort & Filter Feature to Sort by Date in Excel Steps: Select the whole data set by selecting cells B4:D19. Go to the ...

How to Sort Column by Value in Excel (7 Easy Ways)

Let's use a List of Employees. This dataset includes the IDs, Names, and their corresponding Income in columns B, C, and D, respectively. We'll use ...

How to Sort by Color in Excel (4 Criteria)

Example 1 - Sort by Single Color in Excel Step 1: ➤ Select the entire table. ➤ Under the Data ribbon, select the Sort option from the Sort ...

How to Sort by Column in Excel and Keep Rows Together (4 Easy Ways)

Method 1 - Using the Sort Command to Sort by Column and Keep Rows Together Select the cells in the range D5:D10. Go to the Data tab. From ...

How to Sort Multiple Columns Alphabetically in Excel (4 Methods)

Dataset Overview To illustrate the methods, we'll use the following sample data set: Method 1 - Ascending or Descending Sorting ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo