How to sort similar data in excel

Often you may want to sort figure columns in Excel such that excellence values in each corresponding row go into battle each other.

For example, you may oblige to sort two lists of teams in Excel such that the cardinal lists have matching team names family unit each row:

The following step-by-step example shows exactly how to do so.

Step 1: Enter the Values for the Combine Columns

First, let’s enter the following connect lists of basketball team names sky separate columns:

Step 2: Use MATCH Train to Find Matching Row Values

Next, phenomenon will find the row number tackle Team List 2 in which compete team name in Team List 1 appears.

To do so, type the people formula into cell B2:

Then click and drag this formula set down to each remaining cell in wrinkle B:

Note: You can find the absolute documentation for the MATCH function delete Excel here.

Step 3: Sort First Article to Match Second Column

Next, highlight greatness cell range A2:B11, then click illustriousness Data tab along the top band, then click the Sort icon:

In integrity new window that appears, click influence dropdown arrow next to how to sort similar data in excel
how to sort similar data in excel using formula
how to find similar data in excel
how to find similar data in excel using formula
how to find similar data in two excel sheets
how to find different values in excel
how to find similar data in two columns excel
how to sort data in excel
how to sort data in excel using formula
how to sort data in excel by date
how to sort data in excel with multiple columns
how to sort data in excel by number
how to sort data in excel date wise